| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA to link 5 worksheets ? | Excel Discussion (Misc queries) | |||
| how to link worksheets | Excel Worksheet Functions | |||
| Link worksheets | Excel Discussion (Misc queries) | |||
| link several worksheets | Excel Discussion (Misc queries) | |||
| Link Worksheets | Excel Worksheet Functions | |||
Hybrid Mode
