VBA Object Projects shows sheets that do not exist

[abschy]

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 with the other symbol "

" all the way until sheet 50+

I am unable to right click and remove those extra sheets and i also do not have any of those sheets hidden..

How do i remove these empty and non-existent sheets?

Thank you!

 

[VBE313]

It looks like it is corrupted

 

[abschy]

It looks like it is corrupted

Is there any way to fix this??:/

 

[RoryA]

You may note that the icon for those non-existent sheets is actually the icon for the ThisWorkbook object, which is usually a sign of corruption, as has been mentioned. Since you only have two sheets, and assuming you see the same thing after restarting Excel and opening the workbook, I'd try copying the contents of each sheet to a new workbook.

 

[abschy]

You may note that the icon for those non-existent sheets is actually the icon for the ThisWorkbook object, which is usually a sign of corruption, as has been mentioned. Since you only have two sheets, and assuming you see the same thing after restarting Excel and opening the workbook, I'd try copying the contents of each sheet to a new workbook.

oh no...i have more than 2 sheets, i've a total of about 30 sheets with approx 25 different queries in this workbook.. is there a way to fix this without having to redo everything?

 

[RoryA]

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.