Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can Macro update "ThisWorkbook" sheet? | Excel Discussion (Misc queries) | |||
Programatically adding macro to Excel - "ThisWorkbook" | Excel Discussion (Misc queries) | |||
Copying "ThisWorkbook" objects | Excel Programming | |||
ThisWorkbook.Path & "\" & .... not WAVFile, but AVI file... | Excel Programming |