View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default 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 :-(