Page 229 - TP_IT_V1.0_C10_flipbpookl
P. 229

•  Switching between windows
                 •  Things not about what’s in the spreadsheet, like changing settings or organising macros
                 •  It only records when you select things using the keyboard, not the mouse
                 •  The macro recorder only works in Calc and Writer.

                 Enabling Macro Recording Feature
                 By default, the macro recording feature is disabled. To use this feature, you need to first enable it. To do this, perform
                 the following steps:

                 Step 1:  Select the Tools   Options option in the Menu bar.
                         The Options dialog box opens.

                 Step 2:  Click on the LibreOffice category. The LibreOffice Base category expands and displays the options.

                 Step 3:   Select the Advanced option. The options related to advance features of LibreOffice displays on the right-side
                         of the Options dialog box.
                 Step 4:  Select the Enable macro recording (may be limited) check box.

                 Step 5:   Click the OK button.


































                 The Macro Recording features is enabled and Record Macro option will be visible under Tools   Macros.

                 Recording Macros
                 Let us create a simple macro of storing the names of five cities and formatting it in a different colour, font and size. To
                 do this, follow the steps given below:

                 Step 1:  Create a new spreadsheet.

                 Step 2:  Select the Tools   Macros option from  the Menu bar.
                 Step 3:  Select the Record Macro option from the submenu.






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