Microsoft Office Tutorials and References
In Depth Information
Automating Commands with Macros
play back in
To unhide the Personal Macro Workbook, first clear the alert dialog box and
close the Macro dialog box; then click the Unhide button on the View tab
(Alt+WU) and click the OK button in the Unhide dialog box while PERSONAL.
XLSB is selected. Excel then makes the Personal Macro Workbook active,
and you can open the Macro dialog box and edit or delete any macros you’ve
saved in it. After you finish, close the Macro dialog box and then click the
Hide button on the View tab (or press Alt+WH) to hide the Personal Macro
Workbook once more.
Assigning macros to the Ribbon
and the Quick Access toolbar
If you prefer, instead of running a macro by selecting it in the Macro dialog
box or by pressing shortcut keys you assign to it, you can assign it to a
custom tab on the Ribbon or a custom button on the Quick Access toolbar
and then run it by clicking that custom button.
To assign a macro to a custom group on a custom Ribbon tab, you follow
1. Choose File ➪ Options and then click the Customize Ribbon tab in the
Excel Options dialog box (or press Alt+FTC).
Excel displays the Customize Ribbon pane in the Excel Options dialog box.
2. Click Macros in the Choose Commands From drop-down list box on
Excel lists the names of all the macros created in the current workbook
and saved in the PERSONAL.XLSB workbook in the Choose Commands
From list box.