excel 2016 quick access toolbar icons very big

Find the commands you want to change icons for and replace the name in the imageMso field to the name of the icon you want (from step 1 above).This file has all the QAT buttons you created earlier Go inside the userCustomization folder and open the only file inside - customUI.xml.Change extension of OneWorkbookQAT.xlsm to.Edit the (currently empty) QAT as usual, add whatever buttons/macros you want.Go to File -> Options -> Quick Access Toolbar and on the right hand side under the option Customize Quick Access Toolbar select For OneWorkbookQAT.xlsm.For simplicity I just removed the default QAT for all documents and have all my settings stored in this addin. You'll need to create a workbook-specific QAT, add your custom macros there, manually edit the image names and then save this file as an auto-loading addin, so that your custom QAT is always loaded and your custom icons are not overwritten during edits of the default QAT. the name of the icon with a zero on it is _0 there might be a more convenient alternative to find icon names, but this was sufficient for my needs of a few icons)Įditing QAT: Below you'll basically find an edited version of instructions from this awesome site Customize QAT Icons, where I originally found the solution.

Choose the ones you need and write down their names from this Icons Gallery (e.g. Icons: as far as I understand, you can only get the stock MS Office icons (which is still a lot more than that measly default selection you're allowed to pick from).

Excel 2016 quick access toolbar icons very big