![]() |
#2
|
|||
|
|||
![]()
Yes, this can be done.
First, if this is for multiple users, I recommend that the customization be done through XML modification with vba rather than using the Modify the Ribbon command in the user interface. Customize the Ribbon (It doesn't take rocket science) by Greg Maxey The template holding the modifications should be loaded as a Global Template. This method makes distributing the custom ribbon much easier. Even if it is just for yourself maintenance will be much easier doing direct XML editing. Second, the templates should be stored in the Workgroup Templates folder. That makes it easy for your ribbon to access templates on different computer systems by simply referencing the Workgroup Templates folder as a base. Third, you should use dynamic menus in your Ribbon rather than individual macros for each template. That way, when you add or delete a template the ribbon will change automatically. Dynamic Ribbon Menu by Greg Maxey Here is a screenshot from such a Ribbon tab. The items listed in the menus are the filenames for the templates. I also use empty templates to act as divider lines in the menus. There are also individual buttons for certain templates. KenyonFormsDocumentationSmall.png The templates are all in a special folder in the Workgroup Templates folder called Menus. The individual menus come from folders in that folder. As you can see there are folders inside those folders that allow a menu tree structure. Fourth, unless you are an experienced coder in vba and xml, expect this project to take a while. The best reference of which I am aware is RibbonX: Customizing the Office Ribbon by Robert Martin, Ken Puls, and Teresa Hennig. Greg Maxey has a number of pages to help. You may also want to look at Ron deBruin's site. While it is about Excel, many of the same methods are used. Once the Ribbon tab is set up, it is simple to make access to the dynamic menus available through the QAT as well. The image above is from a single QAT button. It is also possible to put individual templates that have buttons on the ribbon on the QAT.
|
Tags |
ribbon, templates |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Customizing the ribbon: Message tab on reply | oleander | Outlook | 0 | 10-15-2018 10:17 AM |
![]() |
Rewster | Word | 2 | 05-12-2017 08:19 AM |
How to import the customized ribbon to Word without overwriting the existing Ribbon? | SharonSh | Word VBA | 0 | 09-26-2013 11:47 PM |
![]() |
Mixer | Excel | 3 | 03-19-2013 01:52 AM |
PowerPoint Add-in fails to load in start up but loads successfully if load manually f | shahbazlibra | PowerPoint | 0 | 11-30-2010 08:36 AM |