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
   225   226   227   228   229   230   231   232   233   234   235