PDA

View Full Version : Ribbon tab triggered from another Workbook



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>

Andy Pope
03-11-2013, 06:49 AM
See this article
http://www.excelguru.ca/blog/2007/03/19/sharing-a-custom-ribbon-tab-among-workbooks/

Only sensible approach appears to be an addin

soplo
03-12-2013, 08:01 AM
Thanks a lot Andy. This article gives me more view about ribbon.
Anyway I prefer keeping the excel file in xlsm not xlam. Then let excel makes ribbon tap by default. It works fine.

regards