Hi,
I created the following xml in my .xlam add-in file to load a new tab and menu which works but when I click the Icon, I get the mentioned error . I do not have a separate file open with a same named module which I read can cause this problem. The generate call back and validate identify no issues
Thanks for your help in advance !
As a sidenote, The same macro works fine under the Add-In tab using the below code but I would like it to be under my own tab
I created the following xml in my .xlam add-in file to load a new tab and menu which works but when I click the Icon, I get the mentioned error . I do not have a separate file open with a same named module which I read can cause this problem. The generate call back and validate identify no issues
Thanks for your help in advance !
HTML:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="false">
<tabs>
<tab id="customTab" label="My Menu">
<group id="customGroup" label="Header/Filter">
<button id="customButton" label="Header/Filter" imageMso="HappyFace" size="large" onAction="HeaderFilter" />
</group>
</tab>
</tabs>
</ribbon>
</customUI>
As a sidenote, The same macro works fine under the Add-In tab using the below code but I would like it to be under my own tab
Code:
Set cControl = Application.CommandBars("Worksheet Menu Bar").Controls.Add
With cControl
.caption = "Header/Filter"
.DescriptionText = " "
.HelpFile = "C:.txt"
.TooltipText = "Toggle Header and Filters On/Off"
.faceId = 9246
.Parameter = 2
.BeginGroup = True
.Style = msoButtonIconAndCaption
' .Style = msoButtonCaption
.OnAction = "HeaderFilter"
End With
Last edited by a moderator: