Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars and Crashing
I have an application I have written in which the first
step is to determine if a toolbar exists. If it does, the macro makes it visible. If it doesn't, the macro creates it and makes it visible. When the application closes, it hides the toolbar. This all works well except of the user quits the application without saving, Excel crashes - every time. I have disabled the toolbar portion of the application and the crashing goes away, so I know it's in that area, but I don't understand why it is causing the crashing. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars and Crashing
Hi Mick
I always create a toolbar when the file opens and delete it when I close it In your workbook open event use this lines first to be sure that the toolbar is delete. If Excel crash it is possible that your close event will not run that delete the toolbar On Error Resume Next Application.CommandBars("MyMenuBar").Delete On Error GoTo 0 -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Mick" wrote in message ... I have an application I have written in which the first step is to determine if a toolbar exists. If it does, the macro makes it visible. If it doesn't, the macro creates it and makes it visible. When the application closes, it hides the toolbar. This all works well except of the user quits the application without saving, Excel crashes - every time. I have disabled the toolbar portion of the application and the crashing goes away, so I know it's in that area, but I don't understand why it is causing the crashing. Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars and Crashing
Mick,
Take a look at J-Walk's Add-In. http://j-walk.com/ss/excel/tips/tip90.htm It's an example of creating a Toolbar on the fly. I've used/modified it for my own purposes successfully and it works great. John Mick wrote: I have an application I have written in which the first step is to determine if a toolbar exists. If it does, the macro makes it visible. If it doesn't, the macro creates it and makes it visible. When the application closes, it hides the toolbar. This all works well except of the user quits the application without saving, Excel crashes - every time. I have disabled the toolbar portion of the application and the crashing goes away, so I know it's in that area, but I don't understand why it is causing the crashing. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel Crashing | Setting up and Configuration of Excel | |||
csv files crashing | Excel Discussion (Misc queries) | |||
Crashing of Excel | Excel Discussion (Misc queries) | |||
Help--Excel keeps crashing | Excel Discussion (Misc queries) | |||
Book Crashing | Excel Discussion (Misc queries) |