Hello,

I have an excel file with currently about 10 sheets. It has 1 module,
and some code in the ThisWorkbook Object as well as 1 of the sheets.
Each tab is a daily report - occasionally, I manually delete
worksheet tabs to manage the file size.

I just noticed that in the VBA project, there are many blank (i.e.
Sheet10, Sheet11, Sheet12, Sheet13, etc) Microsfot Excel Code Objects
(31 to be exact) - these objects can be activated and code can be
entered. However, there are only 15 existing worksheet tabs...

The only other notable observation is that the icon for the non-
existing objects in the VB project explorer window are the green Excel
"X", whereas code objects with associated valid worksheet tabs are a
small black table icon.

I suspect the VBA project is corrupt and I will have to figure out a
way to try and start the workbook from scratch...

But has anyone experienced anything like this before, and what can I
do to prevent this from happening in the future?

Thanks,

Lance