Results 1 to 2 of 2

Thread: Use Custom Ribbon for all Excel Workbooks

  1. #1
    Neophyte GordonS's Avatar
    Join Date
    Oct 2017
    Location
    Sunnyvale, CA
    Posts
    1
    Articles
    0

    Question Use Custom Ribbon for all Excel Workbooks



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

    My old workbook with code had a toolbar attached to it that ran the code. I hid the workbook and had it auto load under XLSTART. Only the tool bar was seen and could be used with any workbook that I opened.
    I have created a new workbook with all my code (Macros) in it. I have a Ribbon attached to it that runs the code. Everything works fine; my only problem is, getting the ribbon to work with any workbook loaded. Also if I hide the workbook the ribbon disappears. I have tried loading it under “XLSTART”, as an “add-in” and as a binary file. Is there a way to make the ribbon work with all workbooks and still keep the code workbook hidden?

    Thank you.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,663
    Articles
    0
    Excel Version
    O365
    An addin should do that.

Posting Permissions

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