| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
skip hidden sheets
I have a workbook with about 50 sheets. I have a decision tree that
unhides sheets based on the answers to screening questions. I want to add navigation buttons to allow users to go to the next or previous sheets. When the next sheet is hidden the macro hangs. How can move to the next unhidden sheet? I've tried: activesheet.next.select which didn't work. Any thoughts? thanks in advance, Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Skip Rows in Fill Series and Filter to Two different sheets | Excel Worksheet Functions | |||
| Skip hidden rows while copying down in excel? | Excel Discussion (Misc queries) | |||
| How do I copy information and skip hidden cells? | Excel Discussion (Misc queries) | |||
| Sheets Skip Macro | Excel Discussion (Misc queries) | |||
| skip empty sheets | Excel Programming | |||
Threaded Mode
