Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Sheet turns into a "ThisWorkbook" module

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?




  #2   Report Post  
Posted to microsoft.public.excel.programming
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?






  #3   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Sheet turns into a "ThisWorkbook" module

I don't have GDS installed. Could anything else be causing the behaviour?

"Tom Ogilvy" wrote:

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?







  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Sheet turns into a "ThisWorkbook" module

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.

--
Regards,
Tom Ogilvy

"Rob" wrote in message
...
I don't have GDS installed. Could anything else be causing the behaviour?

"Tom Ogilvy" wrote:

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?









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Macro update "ThisWorkbook" sheet? Don Excel Discussion (Misc queries) 1 February 18th 09 07:58 PM
Programatically adding macro to Excel - "ThisWorkbook" Aerojade Excel Discussion (Misc queries) 3 October 1st 08 12:53 PM
Copying "ThisWorkbook" objects rpgun[_3_] Excel Programming 1 October 25th 04 09:57 PM
ThisWorkbook.Path & "\" & .... not WAVFile, but AVI file... ste mac Excel Programming 0 May 31st 04 10:22 AM


All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"