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
   219   220   221   222   223   224   225   226   227   228   229