Toolbars and Crashing

[Mick]

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?

 

[Ron de Bruin]

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

 

[John Wilson]

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