In Excel, how do i automatically re-direct the cursor to a new spr

[Guest]

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

 

[JE McGimpsey]

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

 

[Guest]

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

 

[vezerid]

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

Menu Insert>Hyperlink... ?

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

 

[Guest]

MIke

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