| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide/Show some worksheets
Is there a way to use VB code to hide/show a group of worksheets at once,
possibly using a wildcard? I have a worksheet that contains many sheets that need to be Veryhidden and Visible quickly and easily without having to go thru the Format/Sheet/Hide menu. Each worksheet is named for a week of the year. (i.e. (Wk 1) 12-1-2008, (Wk 2) 12-8-2008,(Wk 3) 12-15-2008 etc). The current week will always be visible. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide/Show Data | Excel Discussion (Misc queries) | |||
| Show/Hide series | Charts and Charting in Excel | |||
| Show and Hide in Datafield | Excel Discussion (Misc queries) | |||
| Hide and show Rows | Excel Discussion (Misc queries) | |||
| How do I hide and show all toolbars | Excel Worksheet Functions | |||
![Tony S.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
