Page 227 - IT 402 v2.0 class 10
P. 227

Storing a Macro Internally

            When macros are created in Calc, Calc stores the commands in the form of a code. When a macro is run, Calc
            executes this code to run the actions saved by the user.
             he user can view the command file by following these steps:

            Step 1:  Click on Tools menu.
            Step 2:  Click on Macros option.

            Step 3:  Click on Organize Macros option from the sub-menu.
            Step 4:  Click on   en  ce  asic option.

            Step 5:  The   en  ce  asic Macros dialog box will appear on the screen. Click on the macro name.
            Step 6:  Click on the Edit button.

                              1




















                             2                                                                   3

                                                                                                 4






            A code window will appear on the screen where the code for the macro can be seen. Note that each macro
            starts with the keyword Sub and ends with the keyword End Sub.

            Making Macro to Work as a Function
            To make a macro that works as a Function, follow these steps:

            Step 1:  Click on Tools menu.
            Step 2:  Click on Macros option.

            Step 3:  Click on Organize Macros option from the sub-menu.
            Step 4:  Click on   en  ce  asic option.

            Step 5:  The   en  ce  asic Macros dialog box will appear on the screen. Click on the macro name.











                                                                                 More About Spreadsheet        225
   222   223   224   225   226   227   228   229   230   231   232