RibbonX Customization Question
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!! |
RibbonX Customization Question
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!! |
RibbonX Customization Question
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jon Peltier" wrote in message ... 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!! |
All times are GMT +1. The time now is 02:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com