how to delete a very very hidden sheet? (vba sheet1.anyproperty gives error 429)
Posted on 2015-01-31
vba IDE show 4 sheets. Sheet1 and Sheet4 are weird because they have the icon and properties that are normally associated with ThisWorkbook.
I cannot delete those sheets.
Worksheets.count is 2 NOT 4, so I cannot enumerate them using <for each sheet in worksheets>
debug.print typename(sheet1) gives error 429 Activex component cant create object
sheet.visible = true will not compile, it gives "method or data member not found"
I can view the sheets in the IDE and they clearly contain obsolete code like this
Private Sub CommandButton1_Click()
When I use f4 to view properties, Sheet1 & 4 do not have the 13 properties of a normal sheet. Instead, they have the 35 properties that are normally associated with ThisWorkbook.
f4 show that .name is "ThisWorkbook" for BOTH Sheet1 and Sheet4 !!!
How can I delete them? (I don't want to "start over" by copying everything to a new workbook so I will not give points for that answer.)
Here is what the IDE looks like in the project explorer pane
icon codename sheetname
----- --------------- -----------------