Link worksheets

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.
 
B

Bernard Liengme

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
 
L

Lewy

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...
 
Top