Toolbars
Hi
I have a function in a module that creates a toolbar with VBA.
€śShowToolBar€ť
Also a function that deletes (set visual to False).
€śHideToolBar€ť
Now for example:
Wb1 has the modual and then wb2 is opened but wb1 is still open
but inactive, I would like to delete the toolbar when wb2 opens.
When wb2 becomes inactive or whenever wb1 becomes active
again I would like to restore the toolbar.
I have called the function from Worksheet_Activate
WorkSheetDeactivate; Workbook_Open / Close all without
much happiness.
Any help would be greatly appreciated.
|