How to execute macro when selecting user-defined menu in ribbon
I tried to create a workbook with your XML, but it didn't generate the
ribbon for some reason.
--
HTH
Bob
"Mathieu936" wrote in message
...
On 9 juin, 10:10, Mathieu936 wrote:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/
customui"
<ribbon
<tabs
<!-- Add-Ins Ribbon Menu --
<tab id="SpecialFunctionsTab" label="My Special Functions"
<!-- Structural Analysis Library Tools Group --
<group id="GroupBD7020" label="BM7020"
<!-- BD7020 Dropdown --
<menu id="DropdownBD7020" label="BM7020 Manual" size="large"
imageMso="ControlsGallery"
<menu id="Menu01GeneralInformation" label="01 General
Information"
<menu id="Menu02StressReportFormat" label="02 Stress
Report Format"
<button id="ReportPWC" label="Stress Report"
onAction="InsertTool" /
</menu
</menu
</menu
</group
</tab
</tabs
</ribbon
</customUI
any idea?
I would like to change the line <tab id="SpecialFunctionsTab"
label="My Special Functions" for <tab id="SpecialFunctionsTab"
label="My Special Functions" onAction="MyMacro"
However it does'nt work. I tried onAction, onClick, onSelect,
onActivate but nothing works :-(
|