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

