In excel I guess it would be like a set of instructions that will be executed and is usually used to program repeated activities. So I thought hey I got to learn this Macro thing for Excel so I don’t keep typing the same old things over and over again thus now I will probably share with you what I learnt from Ted French at: http://spreadsheets.about.com/od/advancedexcel/ss/excel_macro.htm
The following is based from what I learnt on that particular website. Take note there are print screens from the website. You know what they say, a picture paints a thousand words so go check it out to have a better comprehension of where to find the buttons.
Macro for Excel 2003 uses the VBA editor and the macro recorder. As for the macro recorder, it can be found when you do following:
(Tools>Macros>Record New Macro)
You get this pop up box where you can fill in details so you have the “Macro name:” and then you have a drop down list for “Store macro in” and then a “Description:” box. Take note there are 3 choices one can choose for “Store macro in”.
1) New Workbook -> only accessible in the new excel file.
2) This Workbook -> only accessible in this file.
3) Personal Macro Workbook -> creates hidden file that stores the macros and accessible to ALL excel files.
So apparently as you click “Ok” it starts recording all the clicks and selections that you do and to stop you click on the blue filled square that pops up in a small window or you do the following:
(Tools>Macros>Stop Recording)
To run the saved macro that you just did you do the following:
(Tools>Macros>Macro)
Then select the one you want and click “Run”.
