View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mathieu936 Mathieu936 is offline
external usenet poster
 
Posts: 18
Default How to execute macro when selecting user-defined menu in ribbon

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 :-(