PDA

View Full Version : Use Custom Ribbon for all Excel Workbooks



GordonS
2017-10-24, 10:39 PM
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.

Bob Phillips
2017-10-25, 12:39 AM
An addin should do that.