M
Michelle
I have a workbook that has a toolbar 'attached', plus some code on
BeforeClose and DeActivate which deletes/hides it.
It all works beautifully. Until...
I have a few versions of the workbook, for different purposes, and sometimes
I need to have 2 or even 3 of them open at once...
Suddenly it all goes a bit 'pear-shaped'. the toolbar now refers to the
macros in one of the books, but not necessarily the one that is active.
There are all kinds of problems such as:
Sometimes the toolbar is deleted by closing a book but there is still one of
the other books open - now with no toolbar
Sometimes clicking a button on the toolbar will cause a version of the file
that I had closed to open up again. And other associated problems.
Is there a standard way of handling this issue?
Or a clever solution that will ensure that the toolbar is always refering to
the acrtive book.
Thanks
M
BeforeClose and DeActivate which deletes/hides it.
It all works beautifully. Until...
I have a few versions of the workbook, for different purposes, and sometimes
I need to have 2 or even 3 of them open at once...
Suddenly it all goes a bit 'pear-shaped'. the toolbar now refers to the
macros in one of the books, but not necessarily the one that is active.
There are all kinds of problems such as:
Sometimes the toolbar is deleted by closing a book but there is still one of
the other books open - now with no toolbar
Sometimes clicking a button on the toolbar will cause a version of the file
that I had closed to open up again. And other associated problems.
Is there a standard way of handling this issue?
Or a clever solution that will ensure that the toolbar is always refering to
the acrtive book.
Thanks
M