Unknown/Undeletable VBA Microsoft Excel Object

[scgilbert1]

Hello,
I have a fairly large workbook that uses vba code to add and delete sheets. In reviewing the project explorer, I noticed a few "Sheets" without names (see the picture, sheet24 and sheet25 and there are a few others not seen here). The icon associated with them is similar to the "ThisWorkbook" object. The sheets in question do not have names associated with them.

I am trying to remove these as I believe they are potentially corrupted but I can figure out how.

When I right click, the "Remove Sheet" option is greyed out.
When I left click the object, the properties do update but it appears to be pulling the information from the "ThisWorkbook" object.
I've reviewed the front end pages and cannot see any unaccounted for tabs.
I've tried programmatically deleting without success using "Sheets(index).delete".
I've tried unhiding the sheet before deleting using "Sheets(index).xlsheetvisible" without success.

Any other ways to get rid of these short of attempting to copy all of the data to a new workbook and starting over? (the reason I don't want to do that is that I have a large number of internal connections and named ranges that I don't want to mess with quite yet."

Thank you!

 

[Alex Blakenburg]

The 2 missing sheets have the same icon as ThisWorkbook, this normally signifies a workbook corruption.
In the thread below, Rory suggest the following:

If you start Excel in safe mode (hold down the Ctrl key while starting the application and answer Yes to the prompt), and then open the workbook, do you still see the same problem in the VBE? If so, I think you will have to rebuild.

VBA Object Projects shows sheets that do not exist

Hi all! Something weird has happened to my VBA Objects.. Currently my VBA objects look partly like this: However, in my worksheet, i do not have this many sheets! The only sheets that exist are those with the symbols of Sheet 32 and 33: . I have the projects for the first 30 or so sheets...

www.mrexcel.com

 

[scgilbert1]

The 2 missing sheets have the same icon as ThisWorkbook, this normally signifies a workbook corruption.
In the thread below, Rory suggest the following:

VBA Object Projects shows sheets that do not exist

Hi all! Something weird has happened to my VBA Objects.. Currently my VBA objects look partly like this: However, in my worksheet, i do not have this many sheets! The only sheets that exist are those with the symbols of Sheet 32 and 33: . I have the projects for the first 30 or so sheets...

www.mrexcel.com

Thank you! I tried to find that question but didn't search the right terms.

Off to rebuild...

 

[Alex Blakenburg]

Sorry we didn't have better news for you