Sheet turns into a "ThisWorkbook" module

R

Rob

When my procedure deletes a specific sheet, instead of it dissapearing from
the project explorer pane, it remains there. After I save and re-open the
workbook, its icons changes to be the same as the ThisWorkbook module, and
it's property options become those of the Thisworkbook module. I'm running
Excel 9, which causes this to happen. If I try to open the workbook after
the change is made then Excel 9 crashes, presumably confused by the existance
of multiple ThisWorkbook modules. Excel 10 opens the file, and in the
project explorer window, shows multiple Thisworkbook modules. Has anyone
experienced this of anything similar?
 
T

Tom Ogilvy

I don't have any additional information. If it is only one workbook, I
would say the workbook is corrupted. If it is a reproducible problem, then
I can't say.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top