• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

How to create a new macro in excel 2003

an anyone tell me how to create a new macro ?

I can only see options to run and record.

I want to open a blank macro and paste into it
0
Europa MacDonald
Asked:
Europa MacDonald
1 Solution
 
Patrick MatthewsCommented:
1) Hit Alt+F11 to get to the VBA Editor

2) Add a new module to your workbook's VBA project

3) Add a new procedure by typing "Sub MacroName" in the module, and hitting Enter

4) Add your code
0
 
terencinoCommented:
Or you can go Alt+F8 to bring up the Macro dialog, type in the name of the macro, select This Workbook (or whatever workbook you want the macro in) from the drop down, then hit Create button and it will do the rest that Patrick has listed above.
Macro dialog Alt F8You might want to open the Macro dialog again later and then select Options to add a keyboard shortcut and a description if you want. The Macro dialog is a convenient place to manage your macros from, if you're just starting out, you can also Edit & Step Into them. Macro Options
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now