Corrupt Visual Basic Project?

[Lance]

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

 

[Matthew Herbert]

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

Lance,

Have you checked what the Visible property is set to for your "blank"
worksheets? Do you want to delete these "blank" worksheets? (No, I
haven't experienced this "green Excel X...small black table icon"
difference you mention).

Best,

Matthew Herbert