soplo
03-11-2013, 01:57 AM
Hi,
I just downloaded a Ribbon tweak from Andy Pope website. When I opened the workbook and the macro run well. But when I switch to another workbook the macro is invisible and also completely disable. A macro still visible but disable.
Question is how to enable to trigger ribbon button from different workbook. Is there any method as simple as commandbar in Excel 2003 :banghead:
regards
<ribbon>
<tabs>
<tab idQ="nsAndy:MyTab" label="My Utils">
<group idQ="nsAndy:myGroup" label="Shared Group">
<button idQ="nsAndy:btnAB" imageMso="AdpPrimaryKey" onAction="MyAction" label="Shared AB Shared Group"/>
<button id="Button2" imageMso="Lock" onAction="MyAction" label="Private A Shared Group"/>
</group>
<group id="Group1" label="Private Group A">
<button id="Button1" imageMso="Lock" onAction="MyAction" label="Private Group A"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
I just downloaded a Ribbon tweak from Andy Pope website. When I opened the workbook and the macro run well. But when I switch to another workbook the macro is invisible and also completely disable. A macro still visible but disable.
Question is how to enable to trigger ribbon button from different workbook. Is there any method as simple as commandbar in Excel 2003 :banghead:
regards
<ribbon>
<tabs>
<tab idQ="nsAndy:MyTab" label="My Utils">
<group idQ="nsAndy:myGroup" label="Shared Group">
<button idQ="nsAndy:btnAB" imageMso="AdpPrimaryKey" onAction="MyAction" label="Shared AB Shared Group"/>
<button id="Button2" imageMso="Lock" onAction="MyAction" label="Private A Shared Group"/>
</group>
<group id="Group1" label="Private Group A">
<button id="Button1" imageMso="Lock" onAction="MyAction" label="Private Group A"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>