cancerfixer
New Member
- Joined
- Apr 15, 2011
- Messages
- 6
I have a workbook that is shared by several users via the cloud. Only one user uses it at a time. I created a custom ribbon tab that initiates several macros to manipulate the spreadsheet data. This was done by R clicking on the ribbon and selecting "Customize the Ribbon". When done, it worked great - but only on MY machine. When the workbook is used by another user on their machine, the custom ribbon is not visible anywhere and is not in the customize the ribbon window. When I go through the same process of customization on the other user's computer, the newly re-created custom ribbon becomes available on their machine, but not on anyone else's machine. I have tried to export and import without success. The ribbon does not appear when imported on another user's machine. It seems the custom ribbon is attached to my copy of Excel (2019), but not the spreadsheet - so moving the spreadsheet to another computer does nothing.
Several years ago I was able to create a portable custom ribbon on another spreadsheet using Ron Debruin's custom UI, but since then it has been modified and updated. I was unable to get this version to work, either. It seems I'm just not smart enough to understand what to do. I have researched all over the various boards & found that most recommending creating an add-in and making it a trusted source. I have followed directions to do this with no success. I consider myself a reasonably knowledgeable coder in VBA and Excel, but this task seems beyond me.
Can someone walk me through the process of creating the custom ribbon tab (and contents) so it is attached to the excel file itself and, thus, is portable whenever it is used on someone else's computer? I just can't afford to spend hours updating the ribbon on 10 different computers every time our office decides to change the macro options and execution. Note: Creating shapes (a button shape) with assigned macros is not an option because of the way the sheets are designed which entails deleting and inserting rows and/or columns - even when the buttons are not supposed to move, they usually do. Besides, there is no room. It's gotta be a custom ribbon.
Any help greatly appreciated. I'm on Windows 10 using Excel 2019. Some of the users are on Office 365.
Several years ago I was able to create a portable custom ribbon on another spreadsheet using Ron Debruin's custom UI, but since then it has been modified and updated. I was unable to get this version to work, either. It seems I'm just not smart enough to understand what to do. I have researched all over the various boards & found that most recommending creating an add-in and making it a trusted source. I have followed directions to do this with no success. I consider myself a reasonably knowledgeable coder in VBA and Excel, but this task seems beyond me.
Can someone walk me through the process of creating the custom ribbon tab (and contents) so it is attached to the excel file itself and, thus, is portable whenever it is used on someone else's computer? I just can't afford to spend hours updating the ribbon on 10 different computers every time our office decides to change the macro options and execution. Note: Creating shapes (a button shape) with assigned macros is not an option because of the way the sheets are designed which entails deleting and inserting rows and/or columns - even when the buttons are not supposed to move, they usually do. Besides, there is no room. It's gotta be a custom ribbon.
Any help greatly appreciated. I'm on Windows 10 using Excel 2019. Some of the users are on Office 365.
