Custom Ribbon modification

[leurne]

Hello all


I'm working on a template with lot of macro etc...
we have a customized Ribbon, but i don't understand how it's done because as soon as i save the file .dotm or docx, the customized ribbon disappear (and i still can see in option > customize Ribbon > add-ins and all the stuff but it's gray as it was deactivated...

Problem is: if i want to modify the template, as soon as i save it, i lose this customized ribbon...

I can find in the VBA code, what is the code used, but i can't find how to modify, or add this ribbon...

Do you have an idea?

I used also Custom UI Editor but, it's not exactly same...

[gmayor]

See Customize the Office Ribbon (It doesn't take rocket science)

[leurne]

hi
yes i know this way to customize the ribbon, i was using it. However on the word document that I'm trying to edit, there is nothing (I can't modify it with the software)
So i think they modified it differently.
Also, when i'm saving the word document, the customize ribbon disappear (and that is a function that i would like to keep, it's a bit like an admin mode, only the people who has access to the main word template can use the customize ribbon, then when it's saved in docx, user can't use it).

[Guessed]

If you change the file extension to .zip and look inside it, does it have a file in the CustomUI folder?

[leurne]

Nop, no customUI
just:
_rels
customXml (????)
docProps
word
and a file: [content_types].xml.

I 've searched something related to ribbon or to somehting related in every folder and files, but nothing.

[Guessed]

If you don't have a customUI folder then you don't have ribbon code inside that document.

You can use your Custom UI Editor to place ribbon code in docx document. If that ribbon code relies on macros then the document will need to be a docm.

It is inefficient to place the ribbon code in a docx or docm document. Generally it is better to place the ribbon & macro code in a dotx or dotm template and attach that to the document. You can then attach that same template to lots of other documents so that the code doesn't need to be updated/maintained in lots of places.

[leurne]

the point is , i have a customized ribbon because there is an add-in tab with 4 buttons which call 4 different macro connected to the .dotm document... When i save the document the tab disappear, and when i click on one button, it's changing also the tab button (and 3 new button appears).
I would like to find where is this tab.

I've already make a new tab with customUI but it doesn't fit to what i want....

[leurne]

if it's help, i've just find out a macro which modify my ribbon and remove the button:

.UpdateStylesOnOpen

[leurne]

hop, i found
in fact you can create button also with reference Microsoft ActiveX Data Objects 2.7 Library (not sure it's exactly this one or if it's working with others)

but then i have this option:
Set ObjBouton = ObjBO.Controls.Add(msoControlButton)

and i can modify everything with it. Then it's ok