Page 230 - Trackpad 402_Class-X_Final
P. 230
Step 4: Add the names of five cities, format the list with different colours, font type and size.
Step 5: After you are done with the steps of your formatting the worksheet. Click on Stop Recording.
Step 6: After this OpenOffice Basic Macros dialog box will open as shown below:
Step 7: Click on (+) sign in front of My Macros → Standard → Modules1.
Step 8: Now enter the name of the macros in the text box Macro name. Let us keep it as M1.
Step 9: Click on Save button.
When was macros introduced in OpenOffice Calc?
Running a Macro
After the macro is recorded, you can run it as many times as you want until you delete it from the computer. The steps
to run a macro are as follows:
Step 1: Create a new worksheet or open an existing worksheet where you want to run a macro.
Step 2: Click on Tools menu and select Macros option. Click on Run Macro… option.
Step 3: Open the folders by clicking on (+) sign in front of My Macros → Standard → Module1. The list of macros
within it will be displayed as shown below:
230 Trackpad Information Technology-X

