View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Sheet turns into a "ThisWorkbook" module

Do you have google desktop installed?

check this link and see if it matches your problem:

http://www.dicks-blog.com/archives/2...oogle-desktop/

--
Regards,
Tom Ogilvy

"Rob" wrote in message
...
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?