vicsar
New Member
- Joined
- May 5, 2013
- Messages
- 23
- Office Version
- 2019
- Platform
- Windows
- Web
Overview:
I have a shared macros book that is stored in a file server (I am planning/willing to convert it to an add-in), users run all their macros from the same common drive, every time I make a change in the server side the book is updated on the users’ side.
In Excel 2003 I had a persistent menu that user would refer to in order to use the common macros (use by everyone in the office) that feature was removed in Office 2007 (yep… we just migrated to that).
I tested the same procedure in Office 2010 and 2013 and the menu goes to the add-ins tab… which that kind of works but is not as convenient as having the menu right up front.
The challenge:
What I am trying to achieve is to have a ribbon tab Called Common Macros (or whatever) and under that have buttons calling the different macros we all use; however, this tab must be persistent, meaning that every time I open Excel the tab is visible. Because of the way we are setup using the personal.xlsb is not an option. The ideal solution is having a persistent tab but if that is not possible, I can settle by using a persistent menu in the Quick Access Toolbar. How do I achieve that using VBA? The user should be able to either install the add-in and see the menu or see the ribbon tab or run an installation macro and see the tab or the menu. I must stress that it has to be a persistent tab or menu.
I will be very grateful if anyone can help me on this.
I have a shared macros book that is stored in a file server (I am planning/willing to convert it to an add-in), users run all their macros from the same common drive, every time I make a change in the server side the book is updated on the users’ side.
In Excel 2003 I had a persistent menu that user would refer to in order to use the common macros (use by everyone in the office) that feature was removed in Office 2007 (yep… we just migrated to that).
I tested the same procedure in Office 2010 and 2013 and the menu goes to the add-ins tab… which that kind of works but is not as convenient as having the menu right up front.
The challenge:
What I am trying to achieve is to have a ribbon tab Called Common Macros (or whatever) and under that have buttons calling the different macros we all use; however, this tab must be persistent, meaning that every time I open Excel the tab is visible. Because of the way we are setup using the personal.xlsb is not an option. The ideal solution is having a persistent tab but if that is not possible, I can settle by using a persistent menu in the Quick Access Toolbar. How do I achieve that using VBA? The user should be able to either install the add-in and see the menu or see the ribbon tab or run an installation macro and see the tab or the menu. I must stress that it has to be a persistent tab or menu.
I will be very grateful if anyone can help me on this.
