View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default 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