-
Ribbon tab triggered from another Workbook
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
regards
[VBA]
<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>
[/VBA]
-
See this article
http://www.excelguru.ca/blog/2007/03...ong-workbooks/
Only sensible approach appears to be an addin
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules