What if you want to customize the QAT for one particular workbook? Excel will not save this in the Excel.qat file, but will save the QAT setup in the userCustomization folder in a file named customUI.xml inside the workbook file. When you do this for all workbooks, Excel will save the setup in the Excel.qat file as described above. You have the option to add commands to the QAT for all workbooks or only for one workbook. How do you Customize the QAT for One Workbook? Tip: You can right-click on the green circle button for the Add-ins command, and then click Remove from Quick Access Toolbar to delete it. Note: The Excel.qat file will not exist if you have not customized your QAT. However, you do not have this option for the built-in commands from the user interface, such as the Add-ins command.Įxcel saves your QAT setup in a file named Excel.qat.Ĭ:Documents and SettingsLocal SettingsApplication DataMicrosoftOFFICEExcel.qatĬ:UsersAppDataLocalMicrosoftOfficeExcel.qat If you select Macros in the Choose commands from dropdown, and then add a button for a macro to the QAT, you can use the Modify button to choose one of the 181 images available when using this dialog (there are a total of 1871 images, but more about that later). After doing so, you should see that your QAT looks like this now:
I then added the Add-ins command to the QAT. In the example shown above, I chose Commands Not in the Ribbon in the Choose commands from dropdown list. Tip: You can also right-click on a control in the Ribbon, and then click Add to Quick Access Toolbar.
You can add buttons for all your favorite commands to the QAT this way. In the Choose commands from dropdown make your choice, select the command you want, and then click Add: Right-click on the QAT in the upper right corner of the Excel 2007 window, and then click Customize Quick Access Toolbar: One reason you might want to change a button’s image is that a lot of commands use the same button image (a green circle).įor more information about adding missing built-in commands to the QAT or Ribbon see: How do you Customize the QAT for All Workbooks? It also shows an example of how you can change the image of a QAT button. This post shows you how to add a button to the Quick Access Toolbar (QAT) for one or all workbooks. You can find more useful tips from Ron and links to Excel add-ins at his website:
Today’s author is Ron de Bruin, an Excel MVP.
0 kommentar(er)
