Hello ,
To facilitate the use of macros by an average user, I created and rename a Command Bar "Toulouse Macro" on the tape on Excel and place my macro button on it. When I open this Excel file on my own computer I do have the section "Toulouse Macro" .But to test the macros I sent the Excel file to my superior.
Unfortunately, when he opens it on his computer, the created command bar don't appear.
I wonder if there is no way to lock and keep the created Command Bar on the custom ribbon of Excel so that everyone can use it without going through the creation of buttons directly on the sheet.
Here are the sections created on the ribbon with the macros button that I would like to keep lock in this TEMPLATE_.xlsm.
I would appreciate your help.
To facilitate the use of macros by an average user, I created and rename a Command Bar "Toulouse Macro" on the tape on Excel and place my macro button on it. When I open this Excel file on my own computer I do have the section "Toulouse Macro" .But to test the macros I sent the Excel file to my superior.
Unfortunately, when he opens it on his computer, the created command bar don't appear.
I wonder if there is no way to lock and keep the created Command Bar on the custom ribbon of Excel so that everyone can use it without going through the creation of buttons directly on the sheet.
Here are the sections created on the ribbon with the macros button that I would like to keep lock in this TEMPLATE_.xlsm.
I would appreciate your help.