Forum Discussion
Personalized Ribbons ... Can it be done for a particular workbook?
I have a series of VBA procedures that I would like to make available to the user of a spreadsheet and I'm investigating various ways to present them to the user. I've checked out control buttons (on the sheets), active-x button (on a User Form), and modifying the quick access bar. I'm now looking at the ribbon.
In terms of looks and ease of use, adding a tab to the ribbon looks to be the best way. However, it seems I have to make the ribbon changes for all my spreadsheets. Is that correct? Is there a way I can modify the ribbon, say during the workbook activate routine, and the reset it during the workbook exit routine?
I've finished beating my head against the wall. I noticed that the macro recorder doesn't record anything (doesn't even create a sub shell) when adding something to the ribbon. That, along with the fact that no one has commented to my first note, cause me to conclude that it can't be done. Let me know if you know otherwise. And thanks for reading anyway.
Meanwhile, I'll close this thread.
2 Replies
I've finished beating my head against the wall. I noticed that the macro recorder doesn't record anything (doesn't even create a sub shell) when adding something to the ribbon. That, along with the fact that no one has commented to my first note, cause me to conclude that it can't be done. Let me know if you know otherwise. And thanks for reading anyway.
Meanwhile, I'll close this thread.