Macros in Word and Excel provide the ability to save time on predictable, repetitive tasks. You can and then simply click a button to run the macro and perform the task. Once you’ve recorded your macro (see our article at the above link), you can add a button to the Quick Access Toolbar so you can quickly run the macro. To do this, click the down arrow button on the right side of the Quick Access Toolbar and select “More Commands” on the popup menu.

By Geetesh Bajaj, James Gordon. Customize your toolbars in Microsoft Office 2011 for Mac to increase efficiency and productivity. By making your own toolbars in Office 2011, you avoid repeating same toolbar in each window —which is what happens if you stick with the ones that come with Word, PowerPoint, and Excel. Zotero Toolbar missing in Word 2011. November 1, 2011. II have just downloaded Zotero and run into the same problems with the toolbar in Word 2011 for Mac running Lion. I'm running the standalone and Safari. Office 2011 does support VBA Macros (unlike 2008). I've made 3 changes and now both the script menu has the 'Zotero.

The “Excel Options” dialog box displays with the “Customize the Quick Access Toolbar” screen active. Select “Macros” from the “Choose commands from” drop-down list.

Select the macro you want from the list below the “Choose commands from” drop-down list and then click “Add”. The macro is added to the “Customize Quick Access Toolbar” list. Click “OK” to accept the change and close the “Excel Options” dialog box. Macros can be recorded in Word and Excel. We showed you how to add a macro to the Quick Access Toolbar in Excel 2016, but this procedure will also work in Excel 2013 and Word 2013 and 2016. NOTE: Macros are essentially bits of computer code and are potentially dangerous.

For more information, see our article about.