| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test for if sheet is HIDDEN
See if this code snippet helps you...
Dim WS As Worksheet For Each WS In Worksheets If Not WS.Visible Then Debug.Print WS.Name & " is hidden." End If Next Rick Am trying to step through sheets, and if one is hidden, so indicate.... This line don't seem to work If ActiveSheet.Visible = False Then "DoThis" Else "DoThat" Endif Any suggestions please? Vaya con Dios, Chuck, CABGx3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
| How to test to see if a given sheet from is in a workbook from ano | Excel Programming | |||
| test if a sheet exist (with the name) ? | Excel Programming | |||
| Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming | |||
| Problem pasting a row from a hidden sheet to the first free row on another visible sheet | Excel Programming | |||
Threaded Mode
