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.
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?
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.
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.
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.
Best video on how to tweak the Excel Ribbon! Thank you!
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.
Very good example and introduction for this topic.
Thanks l, finally I understand how to modify the buttons.
this is awesome
Thank you so much.
like ,usefule tip
nice tutorial! It would be great if you share the link of the names of all group! thanks
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?
sir how do i hide "File" ribbon? and "Design" ribbon (when there is a table format in sheet)
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?
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.
How do i assign a custom icon(not one from the group excel gives you) to a button on the quick access toolbar?
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.
Can you use this product to launch excel files from the button
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.
@@h2e Perfect i will try. Just revisited this video as i have a new project that requires buttons. Great video
How do you create the ribbon so that it is on every excel file you open? rather than just the one you edited
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.
@@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
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.