Page 224 - IT 402 v2.0 class 10
P. 224
Sneak Peek
How to run a Macro in MS Excel?
Perform the following steps to run a macro:
1. Place the cursor in the starting cell.
2. Now, click on Developer Macros option. The Macro dialog box will appear with the list of macros.
3. Select a macro to run from the list and click on Run button.
4. Display result after running macro.
Create Your Own Macro Functions
Calc can call macros as Calc functions.
Use the following steps to create a simple macro:
Step 1: Create a New Calc document named 'Macrodemo.ods'.
Step 2: Click on ‘Tools’ menu and then select ‘Macros’ option. A submenu appears on the screen.
Step 3: lick on Organi e Macros and then OpenO ce asic .
OpenO ce asic Macros dialog box appears on the screen.
The ‘Macro from’ box contains available macro library containers.
My Macros contains macros that user can write or add to OpenO ce.
OpenO ce Macros contains macros included with OpenO ce and should not be changed.
Step 4: lick on Organi er button the OpenO ce asic Macro Organi er dialog box appears on the
screen.
Step 5: Click on the ‘Libraries’ tab.
Step 6: Select the document that will contain the macro.
222 Touchpad Information Technology-X

