Multiple Workbooks Using the Same Custom Toolbar

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top