| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide non active sheets in workbook
Hi,
When a user opens the wb all sheets except one are hidden. There is a custom menu bar with navigation buttons to the sheets. However a user can theoretically open all of the sheets at once using these buttons. I would like for each time a sheet is no longer the active sheet for it to be hidden again automatically - is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hide non active sheets in workbook
If you ammend the code that unhides the sheet to hide any other sheet after
it unhides the one in question. -- Regards, Tom Ogilvy "anon" wrote: Hi, When a user opens the wb all sheets except one are hidden. There is a custom menu bar with navigation buttons to the sheets. However a user can theoretically open all of the sheets at once using these buttons. I would like for each time a sheet is no longer the active sheet for it to be hidden again automatically - is this possible? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hide non active sheets in workbook
On Oct 3, 7:03 pm, Tom Ogilvy
wrote: If you ammend the code that unhides the sheet to hide any other sheet after it unhides the one in question. -- Regards, Tom Ogilvy Thankyou for this - logic if i'd applied my brain really! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I hide scroll bars on specific sheets within a workbook | Excel Discussion (Misc queries) | |||
| Active Hide Emtpy Cells | Excel Discussion (Misc queries) | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| How to hide sheets and VBA code in my Excel workbook? | Excel Programming | |||
| How to hide sheets and VBA code in my Excel workbook? | Excel Programming | |||
Linear Mode
