How do you record more that 1 macro?

Dear Isabel

Thank you for attending Excel Advanced Course. I hope you enjoyed it!

When you say you want to record more than one macro I assume that you want to record them one by one. I’ll quickly explain how you’d go about recording a macro from scratch. Once you have recorded one macro you’d just have to perform the same steps to record other macros.

Please try to be clear about the purpose of creating or recording macros. When you find your self performing repeating tasks over and over it is advisable to create macro. Therefore, you should think of various related actions that you carry out and record them as a macro.
It is also important to be clear about the steps you are going to take once the macro starts to record because any mistakes you make while the macro is recording they will get recorded as well.

Please carry out the following steps to record Macro:

Step 1: Choose Tools > Macro > Record New Macro…

Step 2: In the macro Name please type the name you’d like to give this Macro

(NB: Please do not use space between Words when naming so either use the Underscore or simply use the TitleCase if you have more that one word as a name for the macro.)

Step 3: You can assign a shortcut key if you want.

(NB: Try not to assign a shortcut key which is common such as CTRL+ C or CTRL+ P as they have already been taken. Use the shift key and then a Letter for the shortcut keys)

Step 4: Choose where you’d like to store the macro. The options are:

This Workbook: The Macro will be available only on the current workbook
New Workbook: The Macro will be available to any new workbook
Personal Macro Workbook: The Macro will be available to any existing workbook that you open.

Step 5: It is advisable to provide some description about the macro stating what it intends to do.

Step 6: Press OK button.

Once you press Ok button you’ll notice that a new Macro toolbar will appear and also on the bottom left hand corner of the status bar you’ll notice Recording will appear.
Please remember that macros are normally Absolute which is ok if you are recording things like Formatting or page setup, etc... But if the macro is going to perform calculation and you want refer to related cells then please click the Relative referencing button on the Macro Toolbar.

Step 7: Perform the group of actions while the macro is recording and then once you have finished then simply click the Stop button on the Macro Toolbar.

If you want to create a new macro performing other actions simply repeat steps 1-7.

If this reply has helped answering your query then I would request you to please mark this question as resolved. If not then you can either reply back to this question for further explanation or post a new question the forum.


Kindest Regards

Rajeev Rawat

MOS Master Instructor 2000 and 2003