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?

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
--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Jim Moberg" <(E-Mail Removed)> wrote in message
news:4B4D0EFA-9EE2-48D6-8CF9-(E-Mail Removed)...
> 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?

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,
>
> 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?

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

"Don Guillett" wrote:

> 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
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "Jim Moberg" <(E-Mail Removed)> wrote in message
> news:4B4D0EFA-9EE2-48D6-8CF9-(E-Mail Removed)...
> > 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?
>
>
>

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



--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Jim Moberg" <(E-Mail Removed)> wrote in message
news:51266C94-0013-4345-BEC1-(E-Mail Removed)...
> Thanks Don. I'm not experienced with putting code in like that.
>
> "Don Guillett" wrote:
>
>> 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
>> --
>> Don Guillett
>> SalesAid Software
>> (E-Mail Removed)
>> "Jim Moberg" <(E-Mail Removed)> wrote in message
>> news:4B4D0EFA-9EE2-48D6-8CF9-(E-Mail Removed)...
>> > 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?
>>
>>
>>

Hi Pete,

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

"Pete_UK" wrote:

> 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,
> >
> > 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?
>
>
>