How can you set a column of cells to be hyperlinks?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Moberg - 08 Feb 2007 16:02 GMT

Hi,

I'm trying to set a column of cell values to be hyperlinks so that when
clicked on a web page will open showing the information for the paricular
order selected from the spreadsheet.

What I have done so far is to insert a column next to the column that has
the data in it and use the HYPERLINK function with reference to the cell to
the left. That works just fine but now I want to get rid of the column to
the left and leave just the column with the hyperlnks in it. If I remove the
column then the cell reference is bad because the cells have been removed.

What can I do to get this to work?

Reply to this Message

Don Guillett - 08 Feb 2007 16:21 GMT

Why not just use a double_click event on the original data instead. From my
menu page

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Application.DisplayAlerts = False
Dim WantedSheet As String
WantedSheet = Trim(ActiveCell.Value)
If WantedSheet = "" Then Exit Sub
On Error Resume Next
If Sheets(ActiveCell.Value) Is Nothing Then
GetWorkbook ' calls another macro to do that
Else
Sheets(ActiveCell.Value).Select
ActiveSheet.Range("a4").Select
End If
Application.DisplayAlerts = True
End Sub

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hi,
>
[quoted text clipped - 11 lines]
>
> What can I do to get this to work?

Reply to this Message

Jim Moberg - 08 Feb 2007 16:30 GMT

Thanks Don. I'm not experienced with putting code in like that.

> Why not just use a double_click event on the original data instead. From my
> menu page
[quoted text clipped - 29 lines]
> >
> > What can I do to get this to work?

Reply to this Message

Don Guillett - 08 Feb 2007 16:45 GMT

right click sheet tab>view code>copy/paste the macro>type something in a
cell and double click on it. For instance, type in a sheet name and then
double click on the sheet name

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Thanks Don. I'm not experienced with putting code in like that.
>
[quoted text clipped - 38 lines]
>> >
>> > What can I do to get this to work?

Reply to this Message

Pete_UK - 08 Feb 2007 16:24 GMT

You can fix the values in your column with the formulae in - highlight
all the cells and click <copy>, then Edit | Paste Special | Values
(check) | OK then <Esc>. You can then remove the first column.

Hope this helps.

Pete

On Feb 8, 4:02 pm, Jim Moberg <JimMob...@discussions.microsoft.com>
wrote:

> Hi,
>
[quoted text clipped - 9 lines]
>
> What can I do to get this to work?

Reply to this Message

Jim Moberg - 08 Feb 2007 17:38 GMT

Hi Pete,

I tried this and it didn't work for me. The value was pasted but the value
was then not a link.

> You can fix the values in your column with the formulae in - highlight
> all the cells and click <copy>, then Edit | Paste Special | Values
[quoted text clipped - 19 lines]
> >
> > What can I do to get this to work?

Reply to this Message