Hide unhide custom toolbar (title change)

How do you make a custom tool bar inactive when no workbooks are open?
Greyed out, but some what visible?

Possibly cross referenced to this post of mine.
http://www.excelforum.com/excel-prog...is-active.html

You'd have to disable all its controls

oops, wrong post.

Im stuck at a point on how to make my code work when any workbook opens or closes.

Do I have to place code in every workbook?

what I have now.

Please Login or Register  to view this content.

The above is only affective when I start Excel (personal.xls), part of the tool bar creation macro.
What can I do when I close and or open other workbooks to make the toolbar visible or invisible?

You have two options I can think of:
1. Declare an Application variable WithEvents and use that to trap the opening and closing of other workbooks.
2. Use built-in menu items on your toolbar that already behave the way you want, and hook their click events to run your code. That way, the disabling and enabling is done for you.

Option 1, What? LOL
Option 2, I think I can do that.
Thank you.