Avatar of jobprojn
jobprojn
Flag for United States of America

asked on 

Excel 2007 Ribbon VBA Callbacks

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.onLoad
Sub ribbonloaded(ribbon as IRibbonUI)
End Sub
 
'Callback for DataRangeProperties onAction
Sub DisableDataRangeProperties(control as IRibbonControl, ByRef cancelDefault)
End Sub
 
'Callback for Connections onAction
Sub DisableConnections(control as IRibbonControl, ByRef cancelDefault)
End Sub
 
'Callback for ConnectionProperties onAction
Sub DisableConnectionProperties(control as IRibbonControl, ByRef cancelDefault)
End Sub

Open in new window

Visual Basic ClassicMicrosoft Excel

Avatar of undefined
Last Comment
Rory Archibald

8/22/2022 - Mon