View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Papa Jonah Papa Jonah is offline
external usenet poster
 
Posts: 148
Default delete toolbar on workbook close

I want to delete a toolbar when a workbook is closed.
I have two custom toolbars that I am using.
First a toolbar opens when I open a workbook.
When some macros are run, another workbook is created - call it "New" (for
purpose of this explanation.
After a series of macros run, a second toolbar is created. I would like the
second toolbar to be deleted when "New" is closed. My attempts to use
workbook_beforeClose and workbook_deactivate are failing.

I would appreciate any help.
TIA