| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error '1004' on hiding worksheets
I have this code in
Private Sub Workbook_Open() ActiveWorkbook.Sheets("Cost&Marg_01").Activate Dim sh As Worksheet For Each sh In ActiveWorkbook.Sheets If sh.Name < "Cost&Marg_01" Then sh.Visible = False Else sh.Visible = True End If Next End Sub I get an applicaton defined or object defined error when it gets to the sh.Visible=False line. What have I improperly defined here? Brent |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run-time error 1004 while conditionally hiding rows as a result ofworksheet protection | Excel Discussion (Misc queries) | |||
| 1004 Error when hiding/unhiding rows | Excel Discussion (Misc queries) | |||
| Run-Time error '1004' | Excel Discussion (Misc queries) | |||
| Run time error 1004, General ODBC error | New Users to Excel | |||
| Run-time error 1004 | Excel Programming | |||
Threaded Mode
