How to Customize the Excel Ribbon Using the Custom UI Editor

[@stefanogattoCH]

Best video on how to tweak the Excel Ribbon! Thank you!

[@clairerovic]

Thankyou, I have been trying to get a clear understanding of this for awhile now - using MS guide is overly complicated. Your video has been the best approach and nice and clear. Thankyou.

[@Adam_K_W]

I've got a well developed Ribbon with groups and buttons that work very well. I'm trying to consolidate a bunch of the buttons together into a dropdown list and am failing miserably. Do you have any content on that?

[@ChristiaanRoest79]

Thanks, is it easy to hide tabs in the ribbon and just add one, besides "File" where i add buttons to go to the different sheets?

[@taostephan5142]

Very good example and introduction for this topic.

[@stefanogattoCH]

So if I understood it well, by using your method the Ribbon will change only when you open the Workbook carrying the specific XML and will change back to what it was, whenever you close that same Workbook (xlsx, xlsm, xlam...). On the other hand, if you use "Options/Customize Ribbon", the Ribbon change will be permanent in Excel, regardless on whether you open or close workbooks. Is this correct?

[@h2e]

Yes if you change the XML then it is attached to that file. So even if you send it to someone else, they will see those ribbon changes. Customizing the ribbon using the Excel options is just how your ribbon looks for your specific computer, for all files; it's your default look. It is not specific to any one file.

[@fieryzou9321]

Thanks l, finally I understand how to modify the buttons.

[@dawnandrewrivero]

nice tutorial! It would be great if you share the link of the names of all group! thanks

[@hasbihadirahmanputra5340]

sir how do i hide "File" ribbon? and "Design" ribbon (when there is a table format in sheet)

[@jimmullaney8899]

How do i assign a custom icon(not one from the group excel gives you) to a button on the quick access toolbar?

[@h2e]

You need to insert the icon through the Custom UI editor, and then reference that icon in the code. I didn't go in too deep on this video as I just wanted to provide a brief overview. However, I've made a note to do a future video on this -- I'll aim to get it out within the next month.

[@peterjames8046]

Can you use this product to launch excel files from the button

[@h2e]

If you're talking about the ribbon, yes. You would need to create a macro to open a file, and then link that macro to one of the ribbon buttons.

[@peterjames8046]

@@h2e Perfect i will try. Just revisited this video as i have a new project that requires buttons. Great video

[@igorkrupitsky]

this is awesome

[@42.phoembunnarae39]

like ,usefule tip

[@RL9VI]

How do you create the ribbon so that it is on every excel file you open? rather than just the one you edited

[@h2e]

That is an even easier process. Just go to File->Options->Customize Ribbon and then you can create a new group, tab, or change an existing one.

[@heshamfouad8886]

@@h2e Hello, A quick question on this, if I use this method, I only have limited options of Icons, how can I add more options if needed

[@KamonchanokLot]

Thank you so much.

[@MAGAMAN]

The ribbon bar is seriously one of the most idiotic things Microsoft has ever invented. And that's saying a lot comping from the long list of idiotic ideas from Microsoft.