Disable Custom Toolbar Buttons
Posted by JAF on March 01, 2000 4:55 AM
I have created a number of custom toolbar buttons which do various time-saving things for me (sort worksheets, highlight formulas, lock formulas etc.)
What I haven't worked out is how to disable these buttons when there is no workbook open.
Some of the default Microsoft icons are ghosted, but become active as soon as a workbook is opened or a new one created. Does anyone know what code I need to do this?