RibbonX Customization Question

[brplummer]

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!!

 

[Jon Peltier]

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

 

[Ron de Bruin]

I like to this in the macro

Very simple

On Error Resume Next
ActiveSheet.Select
If Err.Number > 0 Then
MsgBox "There is no workbook open"
Err.Clear
On Error GoTo 0
Else

'Your code


End If