Results 1 to 2 of 2

Thread: custom ribbon tab not visible for all workbooks

  1. #1

    custom ribbon tab not visible for all workbooks



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have an xlam file dedicated exclusively for the displaying a custom ribbon tab (I created it with Andy Pope's excellent addin). Normally the tab is visible for all workbooks. But I've encountered a situation where it is not always displaying for a workbook opened with a Workbooks.Open statement in VBA. What could cause this?

    Thanks,

    Brian

  2. #2
    I have found most of the answer to my question. The default Label property of my tab is empty because it is intended to be filled in by the GetLabel callback at run time. The reason for that is to use a language not known until the ribbon is loaded.

    When a VBA macro opens a workbook, GetLabel doesn't get called until after that macro finishes. If that macro is stopped by a breakpoint or runtime error before finishing, the ribbon callbacks don't get called, and the label of my tab is empty. The tab is actually in the ribbon, but it has a blank label.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •