Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I would like to hide all sheets in a workbook except a sheet with Code Name wksAdmin. The following code produces error message: object does not support this property or method. I know i'm referencing wksAdmin incorrectly, but not sure why. thanks for any help. Sub HideAllSheetsExceptAdmin() Dim wksSheet As Worksheet For Each wksSheet In ActiveWorkbook.Worksheets If wksSheet < wksAdmin Then wksSheet.Visible = False End If Next wksSheet End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
Find Worksheet code names from PowerPoint 2007 | Excel Programming | |||
Code to create worksheet names based on the values in the selectedrange | Excel Programming | |||
how to copy workbook names and worksheet names to columns in acces | Excel Programming | |||
return all worksheet tab names and chart sheet tab names in report - an example | Excel Programming |