I just disabled a few buttons in Excel 2007 by using the Office 2007 Custom UI Editor. In the editor I generated the Callbacks, but now that I've got them into an Excel vba module I'm not sure what to do with them.
Simply put, I want to allow allow myself to 'renable' the buttons that I disabled in the ribbon directly in VBA and not have to open the UI Editor each time.
Below are the Callbacks that the Custom UI Editor generated. Any advice is appreciated.
'Callback for customUI.onLoadSub ribbonloaded(ribbon as IRibbonUI)End Sub'Callback for DataRangeProperties onActionSub DisableDataRangeProperties(control as IRibbonControl, ByRef cancelDefault)End Sub'Callback for Connections onActionSub DisableConnections(control as IRibbonControl, ByRef cancelDefault)End Sub'Callback for ConnectionProperties onActionSub DisableConnectionProperties(control as IRibbonControl, ByRef cancelDefault)End Sub