Consulting

Results 1 to 3 of 3

Thread: Ribbon tab triggered from another Workbook

  1. #1
    VBAX Newbie
    Joined
    Nov 2009
    Posts
    5
    Location

    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]

  2. #2
    MS Excel MVP VBAX Mentor Andy Pope's Avatar
    Joined
    May 2004
    Location
    Essex, England
    Posts
    344
    Location
    See this article
    http://www.excelguru.ca/blog/2007/03...ong-workbooks/

    Only sensible approach appears to be an addin
    Cheers
    Andy

  3. #3
    VBAX Newbie
    Joined
    Nov 2009
    Posts
    5
    Location
    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
  •