Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with vb.veryhidden
Please help!
I am trying to very hide every worksheet in this workbook except for 3- one called RegionalControl, RegionalHelp, and one containing the word competition. Every time the code executes, it tells me it is unable to set the visible property. Here is my code: Dim curwkbk As Workbook Set curwkbk = ThisWorkbook Dim wks As Worksheet Dim wksname As String For Each wks In curwkbk.Worksheets wksname = wks.Name If LCase(wks.Name) Like "*total*" Then Worksheets(wksname).Visible = xlSheetVeryHidden ElseIf LCase(wks.Name) Like "*Competition*" Then 'nothing ElseIf wks.Name = "RegionalControl" Then 'nothing ElseIf wks.Name = "RegionalHelp" Then 'nothing Else Worksheets(wksname).Visible = xlSheetVeryHidden End If Next wks Thanks for any help you can give me! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
Unable to password-protect "VeryHidden" worksheet | New Users to Excel | |||
Sheet hidden and VeryHidden | Excel Discussion (Misc queries) | |||
Accessing a "veryhidden" sheet | Excel Programming | |||
Stuck myself - can't bring back "VeryHidden" | Excel Programming |