how to add my own Ribbon?

[jamiguel77]

hi all, my question is simple:

How to add my own Ribbon / buttons on excel?

see a sample: https://imgur.com/a/X5TLlZl

i want add this ribbon(personal ribbon) when user open excel, the ribbon stay here....

how to do this?
Thanks.

 

[Michael M]

Have a look here for how to add Custom items to your ribbon

https://www.contextures.com/excelribbonaddcustomtab.html

 

[jamiguel77]

hi friend, thanks for answer.

i know how to create a button in standard ribbon, ( asigned my VBA code ).

but the problem is, when user open Excel not see the button, need reopen the file, and i see the button.

how to load automatically the button?

thanks

 

[My Aswer Is This]

I assume users like custom Ribbons so they can click on a icon and run a Macro.
And the QAT may not be what they want because maybe it's limited and you cannot add custom icons.

What I have done is created myself a Modeless UserForm. Which I have in my Personal workbook

On this Userform I have several Multipage pages

On these pages I have Option buttons with captions that tell me what happens if I choose this Option Button

And each Option button activates a different Macro.

I have my Macros sorted into different categories and have a Multipage Page for each different category of Macro.

With my Userform in my Personal Workbook it's always available no matter what Workbook I have Open

I activate the Userform by having a Keyboard shortcut assigned to a Script in my Personal Workbook.

Doing it this way I have nearly 40 different Macros I can launch from clicking on Option buttons.

Just a thought you may want to consider.

Opening the UserForm as modeless means it can stay visible while you work on your Worksheets.

I have another similar Userform with a Listbox that loads in all the sheet names in the active Workbook. When the UserForm is opened via a shortcut key.

And as I select the name in the listbox that sheet is activated.

You have a quick way to activate any sheet even if you have 100 or more.

 

[Michael M]

Are you saying you need to open the file twice before it appears ??
What version are you using?
2010 onwards has an option for customising the ribbon !
There is more about permanency here

https://stackoverflow.com/questions/24052944/customize-ribbon-permanently