Multiple Workbooks Using the Same Custom Toolbar

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I create a custom toolbar and it works fine when I open another instance of
the workbook.

When I close one of the workbooks, my toolbar is deleted. Is there a way to
make sure the toolbar does not get deleted if I have a workbook that requires
the workbook?

Thanks
 
Hi Ken

Add your code in the activate event and deactivate event of the workbook
instead of the open and beforeclose event
 
Back
Top