Multiple Workbooks Using the Same Custom Toolbar

[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

 

[Ron de Bruin]

Hi Ken

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

 

[Ken]

Hi Ron,

I'll give that a try and see how it goes.

Ken