delete custom toolbar

[billQ]

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

 

[Ron de Bruin]

Try this events

Private Sub Workbook_Activate()

End Sub

Private Sub Workbook_Deactivate()

End Sub