You probably need an add-in loaded that has an application events class
module (look for events on
http://cpearson.com). Whenever the workbook_open,
_close, _activate, and _deactivate events fire, you need to test for
workbooks.
1. Check for ActiveWorkbook Is Nothing
2. As stated, in an add-in (perhaps the one with the ribbon customization).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
wrote in message
...
I have a RibbonX customization for Excel. It's quite simple and it
works fine... But, I'm trying to make the buttons that I have behave
like the controls in Excel such that when there is no Workbook visible
in Excel I want to disable the buttons.
It appears that I want to invalidate my buttons and call the "enabled"
dynamic attribute, but I can't figure out 2 things:
1. How to recognize that the Excel Workspace has no visible
Workbooks, and
2. Where to put the code the will recognize when a Workbook has been
closed or hidden so that I can do the test in #1 and respond
accordingly.
Thanks for the help!!