Note: Update Mac Office first and be sure it is 15.17 or higher, in the 15.17 update Ribbon customization via Ribbon XML is enabled by default for all customers. Change the Ribbon in Mac Excel 2016 and up. I tried to reopen the workbook, it did save and the Home ribbon are clickable. Microsoft Excel for Mac version 16.15 (180709) 4. The conditional formatting is applied first then the next thing you know is the Home ribbon is greyed out though the other ribbon (ex. Is there a MUCH larger selection of buttons available? There are only 180 in the button selection window.ħ.2.

Just one more step I'd like to eliminate if possible.Ħ. ico work? I use Liquidicon on my 03 machine to create. Surely there must be a way to copy & paste icons into the folder that they reside in? What is this folder name?ĥ. Do I really have to go through the rigmarole of the Custom UI Editor to import my own icons? It seems very long winded compared to the old Button Editor in 2003 where I could make my own icons on the spot for each button.

How can I determine what the button size is before I select it?There is no indication of the button size when renaming a command in the Group.Ĥ. Is this a default or is there a way of getting them small?ģ. The first Group buttons will only appear as large. As soon as I go to customise the Ribbon again it has disappeared from the list (in the Cust window). For example, I have just added Thick Outside Borders to the Borders group, and when I went back to the sheet the Ribbon is showing it. Is there a limit to either the number of Groups in a Tab, or the number of buttons per Group or Tab? I'm finding that some of the buttons on the last Group keep dropping off. So, directly to some questions please, and all to do with customising the Ribbon (apparently I'm one of the few that like it - I see much wailing and gnashing of teeth on the Net).ġ. I had many customised toolbars that I have coded, but of course I've forgotten a great deal of how that happened. So no previous experience whatsoever with the ribbon before two days ago. Nine year old Dell becomes new Toshiba, XP directly to Win 10, Excel 2003 directly to 2016. I haven't had the need for an Excel forum for many years, but I'm just changing my computer, OpSys and Excel version.

Excel 2016 ribbon editor