Hi Ken

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Ken" wrote in message ...
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