[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to create a new macro in excel 2003

Posted on 2013-02-03
2
Medium Priority
?
352 Views
Last Modified: 2013-02-03
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
Comment
Question by:Europa MacDonald
2 Comments
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 38849538
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
 
LVL 16

Expert Comment

by:terencino
ID: 38849563
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question