Hi Gino

Use the following events in the Thisworkbook module


Private Sub Workbook_Activate()

End Sub


Private Sub Workbook_Deactivate()

End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Gino" wrote in message ...
I have created a toolbar programatically, the only problem is that the toolbar remains present even if I switch workbooks, and (as
expected) causes errors when someone clicks any button on it. How can I have the toolbar deleted when the workbook changes. I have
no problem deleting the toolbar when the worksheet changes its the whole workbook changing thats got me a bit puzzled.

Anyone know how to do this?

Much appreeciated.