Hi,
I'm using CustomUI to add the VBA routines to the ribbon. However I'm having some issues. Here's the xml setup:
<-customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" >
<-ribbon >
<-tabs >
<-tab id="Merge" insertAfterMso="TabView" label="MergeQuotes">
etc.
<-group id="MQGroup02" imageMso="TableInsertExcel" label="Merge">
<-button id="MQG02B01" label="Merge QAR" imageMso="ImportExcel" size="large" onAction="MergeQAR" />
<-button id="MGG02B02" label="Merge EDR" imageMso="ImportMoreMenu" size="large" onAction="MergeEDR" />
<-/group >
etc.
<-/tab >
<-/tabs >
<-/ribbon >
<-/customUI >
Here's the callback code I'm getting an error on:
'Callback for MGG02B02 onAction
Sub MergeEDR(control As IRibbonControl)
Call MergeWbEDR
End Sub
Error is: Compile error, expected variable or procedure not module.
I've split out the modules for readability with one main sub with all the callbacks. Is there a reason I can't set this up or would I have an error somewhere else ?
thanks,
amphi
Bookmarks