In Excel, how do i automatically re-direct the cursor to a new spr
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
|