Solved

How to create a new macro in excel 2003

Posted on 2013-02-03
2
303 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:MichaelGlancy
2 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

This article will show you how to use shortcut menus in the Access run-time environment.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

943 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now