View Full Version : Ribbon tab triggered from another Workbook

03-11-2013, 01:57 AM
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:


<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 id="Group1" label="Private Group A">
<button id="Button1" imageMso="Lock" onAction="MyAction" label="Private Group A"/>

Andy Pope
03-11-2013, 06:49 AM
See this article

Only sensible approach appears to be an addin

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.