Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIde control
Hi
I have forty worksheets within a workbook. Is there anyway that i can hide 39 which hold all the data and keep sheet one as the master. On the master i have ceated hyperlinks to diffrent workseets within the workbook. Any help Please. Monty |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIde control
selesct all the sheets you want to hide. go to Format--Sheet-- select Hide
to unhide go to format --Sheet-- Unhide "Monty" wrote: Hi I have forty worksheets within a workbook. Is there anyway that i can hide 39 which hold all the data and keep sheet one as the master. On the master i have ceated hyperlinks to diffrent workseets within the workbook. Any help Please. Monty |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIde control
Monty/Nikki
Unfortunately, hidden sheets will not react to hyperlinks. i.e. if hyperlink on Master is to Sheet34, pressing the hyperlink will not reveal or jump to Sheet34. If, by "hyperlinks" you mean just regular links, hiding the sheets will not affect these. Gord Dibben Excel MVP On Fri, 18 Nov 2005 10:09:04 -0800, "Nikki" wrote: selesct all the sheets you want to hide. go to Format--Sheet-- select Hide to unhide go to format --Sheet-- Unhide "Monty" wrote: Hi I have forty worksheets within a workbook. Is there anyway that i can hide 39 which hold all the data and keep sheet one as the master. On the master i have ceated hyperlinks to diffrent workseets within the workbook. Any help Please. Monty |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIde control
thanks so much. I didn't know. :)
"Gord Dibben" wrote: Monty/Nikki Unfortunately, hidden sheets will not react to hyperlinks. i.e. if hyperlink on Master is to Sheet34, pressing the hyperlink will not reveal or jump to Sheet34. If, by "hyperlinks" you mean just regular links, hiding the sheets will not affect these. Gord Dibben Excel MVP On Fri, 18 Nov 2005 10:09:04 -0800, "Nikki" wrote: selesct all the sheets you want to hide. go to Format--Sheet-- select Hide to unhide go to format --Sheet-- Unhide "Monty" wrote: Hi I have forty worksheets within a workbook. Is there anyway that i can hide 39 which hold all the data and keep sheet one as the master. On the master i have ceated hyperlinks to diffrent workseets within the workbook. Any help Please. Monty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
Tab to an ActiveX control? | Excel Discussion (Misc queries) | |||
Variable control tip text | Excel Discussion (Misc queries) | |||
calendar control - formatting | Excel Discussion (Misc queries) | |||
Copying list-box control | Excel Discussion (Misc queries) |