Page 231 - TP_IT_V1.0_C10_flipbpookl
P. 231

This will open the Basic Macros dialog window to save and run the created macro. This dialog box shows three names
                 in the library, which are as follows:
                 •  LibreOffice gives us a library called LibreOffice Macros is provided by LibreOffice and contains modules with pre
                   recorded macros and should not be changed.
                 •  My Macros is the library where we put the macros we create or add to LibreOffice ourselves.
                 •  “Untitled1” is the default name for a new spreadsheet that we haven’t saved yet. Later, when we save the spreadsheet
                   with a new name, “Untitled1” will change to the name we give it.
                 Step 6:  Click on (+) sign in front of My Macros → Standard → Modules1.

                 Step 7:   The name of the macro by default is Main and is saved in the Standard Library in Module1. You can change
                         the name of the macro in the Macro Name Textbox as "CityMacro". Note that :If all the macros will be given
                         the same name then they will overwrite the previous Macro created by that name.
                 Step 8:   Click on Save button.









































                 The macro is saved.

                 Note that:  A Library is a collection of modules which in turn is a collection of macros. A Standard library is present by
                 default when a spreadsheet is created and saved.




                               When was macros introduced in LibreOffice Calc?



                 Rules for naming a Macro, Module or a Library:
                 The name must:
                 •  Contain lower case letters (a..z), upper case letters (A..Z), digits (0..9) or underscore.


                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  229
   226   227   228   229   230   231   232   233   234   235   236