Engineer Joe
Well-known Member
- Joined
- Jun 10, 2005
- Messages
- 549
I've seen alot of callback references to iribboncontrols. This basically means that the control has to be interacted with in order for a piece of VBA code to fire. Can you reference an iribboncontrol from a regular module...something where you just have a sub:
the top of my XML code in my UIeditor looks like this:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
xmlns:Q="Excel 2007 VBA Prog Ref"
******="rxcustomUI_******">
I've tossed this into a regular module:
Dim moRibbon As IRibbonUI
Sub rxcustomUI_******(ribbon As IRibbonUI)
Set moRibbon = ribbon
End Sub
Sub ChangeToggleButton()
Dim QuickKeysToggleButtons As IRibbonControl
set QuickKeysToggleButtons = ?????????????
End Sub
I'd like to get the toggleButton as an object. Is this possible, or can i only refer to ribbon objects by callbacks???? IF I can only refer to them by callbacks, how can i change their attributes without the user interacting with them???
the top of my XML code in my UIeditor looks like this:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
xmlns:Q="Excel 2007 VBA Prog Ref"
******="rxcustomUI_******">
I've tossed this into a regular module:
Dim moRibbon As IRibbonUI
Sub rxcustomUI_******(ribbon As IRibbonUI)
Set moRibbon = ribbon
End Sub
Sub ChangeToggleButton()
Dim QuickKeysToggleButtons As IRibbonControl
set QuickKeysToggleButtons = ?????????????
End Sub
I'd like to get the toggleButton as an object. Is this possible, or can i only refer to ribbon objects by callbacks???? IF I can only refer to them by callbacks, how can i change their attributes without the user interacting with them???