Link worksheets

  • Thread starter Thread starter Lewy
  • Start date Start date
L

Lewy

If i have a menu page on worksheet 1, if i click on cell A 4 how do i get
worksheet 2 to open, A5 to open worksheet 3 and so on. Thanks for any help
forthcoming.
 
Right click the cell (A4)
Choose the Hyperlink item from the popup menu
In the Hyperlink dialog, at left, choose "Existing Places in this Document"
Now choose Sheet2
ETC
best wishes
 
Thank you Bernard, works a treat.

Bernard Liengme said:
Right click the cell (A4)
Choose the Hyperlink item from the popup menu
In the Hyperlink dialog, at left, choose "Existing Places in this Document"
Now choose Sheet2
ETC
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
Click to expand...
 
Back
Top