| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Next & Hidden Sheets Issue
The following procedure creates an error if there is
hidden sheets in workbook. How can I have this procedure ignore the hidden sheets? ... Thanks Sub Set_Page_Preview_Normal() Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets wks.Select ActiveWindow.View = xlNormalView Next wks End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hidden sheets | Excel Discussion (Misc queries) | |||
| 2003/2007 Compatibility Issue - Hidden Sheets | Excel Discussion (Misc queries) | |||
| Chart Issue With Hidden Cells | Excel Worksheet Functions | |||
| Hidden Sheets | Excel Worksheet Functions | |||
| Help! Calling hidden sheets? | Excel Programming | |||
Threaded Mode
