Tab will not hide, can't delete
Posted on 2011-02-24
Hello - we have a old template, developed by someone who is no longer here, that has 16 tabs, one of which does not appear on the spreadsheet, even after doing a Format > Worksheet > Unhide.
The code module for it shows up as a node on the "Excel Objects" in Project Explorer, but even in VBA, ActiveWorkSheet.Delete fails with "Select method of worksheet class failed"
(we wrote a short macro that does a WorkBook.Unprotect, then .Select and .Delete that particular worksheet)
The only way we knew this tab existed was that another macro that is involved in this process blows up when it loops through the workbook to un-hide all the worksheets.
Anybody seen this before? How do you go about deleting a phantom worksheet?