Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I'm getting the error below for the code below for the line that is preceded by '***' - I don't understand why this property cannot be set for this variable. Any input is greatly appreciated! Error: Run-time error '438: Object doesn't support this property or method Code: Dim sh As Worksheet Dim shap 'Select Main Menu, hide all other sheets, and protect Main Menu Sheets("Main Menu").Visible = xlSheetVisible Sheets("Main Menu").Select For Each sh In ActiveWorkbook.Sheets If sh.Name < "Main Menu" Then sh.Visible = xlVeryHidden Else End If Next Sheets("Main Menu").Activate For Each shap In ActiveSheet.Shapes *** shap.Enabled = False Next shap -- Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
code failing in hidden rows | Excel Discussion (Misc queries) | |||
userform Enabled property behavior changes between excel 97 and 2000/3 | Excel Programming | |||
VBA - Code failing in Excel 97 | Excel Programming | |||
Enabled Property of Shapes? | Excel Programming | |||
BackColor property code | Excel Programming |