Ribbon code... Can someone please explain!

[RustyNail]

Hello,

I found this particular piece of code on the Internet at

http://www.rondebruin.nl/win/s2/win012.htm

but it doesn't work for me and I don't understand it. Here it is:

Please Login or Register  to view this content.

Questions

1) Everytime I run any of the macros (Hide ribbon, DisplayRibbon, DisplayRibbon_1, DisplayRibbon_2 or DisplayRibbon_3) it gets trapped in
the MsgBox "Error, Save/Restart your workbook" line???? Why?

2) Who calls this function:

'Callback for customUI.onLoad
Sub RibbonOnLoad(ribbon As IRibbonUI)
Set Rib = ribbon
End Sub

3) Who calls this function:

Sub GetVisible(control As IRibbonControl, ByRef visible)
If myId = "show" Then
visible = True
Else
If control.Id Like myId Then
visible = True
Else
visible = False
End If
End If
End Sub

3) What does he mean by this comment:
'Callback for customUI.onLoad

Does it mean I have to call this from custom UI editor... if so where in CUI???

4) Finally, why doesn't the above sample work for me?

Thanks all for your help
rn

[Andy Pope]

the custom UI editor is just that, an editor for the xml used by ribbonx in excel. You do not run any code in it you only edit the xml text.
ribbonx uses a callback approach. That means there are a set of events that are related to ribbon and you have to provide the name of the routine in the excel file which you want run when they are trigger by excel.

So, onLoad is a callback and "RibbonOnLoad" is the routine it will attempt to run. The routine within the excel file stores a reference to the ribbon object for use when the RibbonRefresh routine is executed.

getVisible is another example of a call back.

I suggest you read Stephen Bullen's chapter on ribbonx
http://www.oaltd.co.uk/DLCount/DLCou...ogRef_ch14.pdf