Link worksheets
 

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.

Link worksheets
 

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


"Lewy" wrote in message
...
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.

Link worksheets
 

Thank you Bernard, works a treat.

"Bernard Liengme" wrote:

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


"Lewy" wrote in message
...
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.