| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to Hide/Unhide Worksheet
I want to do something like this
Sub HideUnhideSheets(myWS As Excel.Worksheet, myHidden As Variant) If myWS.Visible < myHidden Then myWS.Visible = myHidden End If End Sub What I want to do is set it up so that myHidden only allows xlVisible, xlHidden and xlVeryHidden (or whatever they are). How do I do that? Thanks, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| code to hide/unhide rows | Excel Programming | |||
| VB Code to hide and unhide rows | Excel Discussion (Misc queries) | |||
| VB Code to hide and unhide rows | Excel Programming | |||
| Code to hide and unhide cells (SC). | Excel Programming | |||
| Hide/Unhide in Code; Protect, Unlock, etc. | Excel Programming | |||
Threaded Mode
