delete custom toolbar

  • Thread starter Thread starter billQ
  • Start date Start date
B

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
 
Try this events

Private Sub Workbook_Activate()

End Sub

Private Sub Workbook_Deactivate()

End Sub
 
Back
Top