Scribd
Upload
1 views3 pages

Using Macros in Spreadsheet

This document provides a detailed guide on how to use macros in LibreOffice Calc. It outlines the steps to record, save, and run macros, as well as how to organize them within the application. The instructions include navigating through menus and dialog boxes to effectively manage macros.

Uploaded by

mahdiyaf721
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
1 views3 pages

Using Macros in Spreadsheet

This document provides a detailed guide on how to use macros in LibreOffice Calc. It outlines the steps to record, save, and run macros, as well as how to organize them within the application. The instructions include navigating through menus and dialog boxes to effectively manage macros.

Uploaded by

mahdiyaf721
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

UNIT 2:- ELECTRONIC SPREADSHEET (ADVANCED) USING LIBREOFFICE CALC

CHAPTER 2:- USING MACROS IN


SPREADSHEET
Follow the steps given below to record a macro.
 Step 1. Click on Tools > Macros and then click on the Record Macro option.
 Step 2. Now start taking actions that will be recorded.
 Step 3. Once you click on Record Macro option, recording of actions starts and a small alert will be displayed.
 Clicking on "Stop Recording" button will stop the recording of actions.
 Step 4. This will open the Basic Macros dialog window to save and run the created macro.
 Step 5. To save the macro, first select the object where you want the macro to be saved in the Save Macro to list
box.
 Step 6. 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.
 Step 7. Click on Save button.

To run a macro we need to perform the following steps.


 Step 1. Type the heading in cell A1
 Step 2. Use Tools > Macros > Run Macro to open the Macro Selector dialog box.

 Step 3. Select the library and module in the Library list.


 Step 4. Select the macro in the Macro name list.
 Step 5. Click Run to run the macro.

Use the following steps to organize the macro.


 Step 1. Click on Tools > Macros > Organize Macros > LibreOffice Basic to open the LibreOffice Basic Macro dialog window
 Step 2. Click Organizer to open the Basic Macro Organizer dialog

You might also like