delete custom toolbar
 

Hello,
I need to find out where to delete a custom tool bar. Currently, I delete
it in the Before_Close sub of the workbook. The behavior I don't like is
when you choose cancel at the save workbook message box the toolbar is
deleted. Is there a way to handle the messages from the save dialog box to
delete the toolbar only if the workbook is actually closed?
thanks
bill

delete custom toolbar
 

Try this events

Private Sub Workbook_Activate()

End Sub

Private Sub Workbook_Deactivate()

End Sub



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"billQ" wrote in message ...
Hello,
I need to find out where to delete a custom tool bar. Currently, I delete
it in the Before_Close sub of the workbook. The behavior I don't like is
when you choose cancel at the save workbook message box the toolbar is
deleted. Is there a way to handle the messages from the save dialog box to
delete the toolbar only if the workbook is actually closed?
thanks
bill