02-05-2010, 07:33 AM
|
|
Registered User
|
|
Join Date: 05 Feb 2010
Location: India
MS Office Version:Excel 2003
Posts: 1
|
|
|
Creating macros in excel
Please Register to Remove these Ads
I am sharing this information with you all.please add on to this.There are some steps for creating macros in excel
1. Click on Start>Programs>Microsoft office>Microsoft Excel to open the application.
2. Go to Tools>Macro>Record New Macro.
3. A pop up window named Record Macro will appear. Enter a name for the macro under Macro Name field e.g Test Macro; enter a short cut key to be used as a shortcut to execute the macro.
4. Select the location of the macro under Store macro in saving this macro in the Personal Macro Workbook or New Work Book or This Workbook so that it is available when you create new spreadsheets and want to use the macro.
5. Enter a brief description of the macro under Description field and click OK, now you will need to record the activities through the macro
6. A tiny pop up window having a blue button can be pressed at any time to stop recording the steps for the macro.
7. A simple example of macro which can be used in any work book is as follows.
Enter the field names in the rows from A1 to G1. Name, Address, City, State, Zip, Phone, Fax. Then click on the blue button to stop recording the new macro. Remember the shortcut key assigned for macro
8. Testing the macro: Go to File>New to open a new spreadsheet. Press the short cut key assigned for the macro [Ctrl+Shift+C]. You will find that the the field names gets created in the spread sheet automatically.
Thanks
Eliza
__________________
Cheers,
Eliza
|
Linear Mode
