I want to setup an excel cell, such that when it is selected it re-directs
the cursor to a new page in the workbook automatically (like a website
button) it opens the selected page

pse can you advise thanks so much rgds Chris
--
Sorry novice needing help

One way:

Choose Insert/Hyperlink. In the Link To: box, enter an octothorpe
followed by the reference to the worksheet cell to jump to, e.g.:

#Sheet2!A1


In article ,
Cjbrad wrote:

I want to setup an excel cell, such that when it is selected it re-directs
the cursor to a new page in the workbook automatically (like a website
button) it opens the selected page

pse can you advise thanks so much rgds Chris

Hi,

Select the cell and then right click and click hyperlink.

Select 'place in this document' and from there you can set the hyperlink to
take you to any sheet and if you modify the address (it defaults to A1) to
any cell in a worksheets.

If you have created any named ranges you can also direct to them.

Mike

"Cjbrad" wrote:

I want to setup an excel cell, such that when it is selected it re-directs
the cursor to a new page in the workbook automatically (like a website
button) it opens the selected page

pse can you advise thanks so much rgds Chris
--
Sorry novice needing help

On May 31, 2:26 pm, Cjbrad wrote:
I want to setup an excel cell, such that when it is selected it re-directs
the cursor to a new page in the workbook automatically (like a website
button) it opens the selected page

pse can you advise thanks so much rgds Chris
--
Sorry novice needing help

Menu InsertHyperlink... ?

Or else, with an event macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Addrress = "$A$1" Then Sheets("Sheet2").Activate
End Sub

To install, right-click on the sheet tab, choose View Code. WHen the
VBA IDE comes up paste the above code to the Sheet's code window.

HTH
Kostis Vezerides

MIke

Thanks so much absolutely "simple" when you know how. Very much appreciated
.. Regards Chris

--
Sorry novice needing help


"Mike H" wrote:

Hi,

Select the cell and then right click and click hyperlink.

Select 'place in this document' and from there you can set the hyperlink to
take you to any sheet and if you modify the address (it defaults to A1) to
any cell in a worksheets.

If you have created any named ranges you can also direct to them.

Mike

"Cjbrad" wrote:

I want to setup an excel cell, such that when it is selected it re-directs
the cursor to a new page in the workbook automatically (like a website
button) it opens the selected page

pse can you advise thanks so much rgds Chris
--
Sorry novice needing help