Thread: Link worksheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default 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.