[go: up one dir, main page]
Scribd
Upload
43 views3 pages

Chapter 1.7 - Add A Macro To The Toolbar

The document describes how to add a macro to the Excel Quick Access Toolbar so that it can be easily accessed. It involves recording an empty macro, naming it, storing it in the personal macro workbook, then customizing the Quick Access Toolbar to add a button to execute the macro.

Uploaded by

putra.stat11
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
43 views3 pages

Chapter 1.7 - Add A Macro To The Toolbar

The document describes how to add a macro to the Excel Quick Access Toolbar so that it can be easily accessed. It involves recording an empty macro, naming it, storing it in the personal macro workbook, then customizing the Quick Access Toolbar to add a button to execute the macro.

Uploaded by

putra.stat11
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Excel Easy

#1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us

Add a Macro to the Toolbar Search Entire Site Go

If you use an Excel macro frequently, you can add it to the Quick Access Toolbar. This way you can quickly
access your macro. First, we record an empty macro. Chapter < >
1. On the Developer tab, click Record Macro. Create a Macro

Learn more, it's easy


Swap Values

Run Code from a Module

Macro Recorder

Use Relative References

FormulaR1C1

Add a Macro to the Toolbar

2. Name the macro MyName. Choose to store the macro in Personal Macro Workbook. This way the macro will
Macro Security
be available to all your workbooks (Excel files). This is possible because Excel stores your macro in a hidden
workbook that opens automatically when Excel starts. Protect Macro

Follow Excel Easy

3. Click Stop Recording.

4. Open the Visual Basic Editor.

5. Create the macro:


This macro places your name in the Active Cell.

6. Now we can add this macro to the Quick Access Toolbar. Right click the Quick Access Toolbar and select
Customize Quick Access Toolbar.

7. Under Choose commands, select Macros.

8. Select the macro and click Add.

9. You can modify the button that will be added to the Quick Access Toolbar by clicking on Modify. For example,
choose a smiley.
10. Click OK.

11. You can now execute the macro by clicking on the smiley button added to the Quick Access Toolbar.

Result:

12. When you close Excel, Excel asks you to save the changes you made to the Personal Macro Workbook.
Click Save to store this macro in a hidden workbook that opens automatically when Excel starts. This way the
macro will be available to all your workbooks (Excel files).

7/9 Completed! Learn much more about creating macros >


Back to Top: Add a Macro to the Toolbar | Go to Next Chapter: MsgBox

You might also like