Open Office Calc Macro Tutorial
OpenOffice Calc is a spreadsheet program that is packaged with the OpenOffice suite of productivity software. It is similar to the Microsoft Excel program. Macros are a sequence of steps that are recorded to be used multiple times. They can be created in OpenOffice Calc to input text into cells on the spreadsheet, to create a specific layout for the spreadsheet or to perform calculations. Macros can be specific to a certain spreadsheet or can be used with all Calc spreadsheets.
Other People Are Reading
Instructions
-
-
1
Open the OpenOffice Calc program.
-
2
Open the spreadsheet that you want to create a macro for. If you are creating a global macro, open any spreadsheet.
-
-
3
Highlight the "Macros" option under the "Tools" menu at the top of the page. A small sub-menu will appear next to it.
-
4
Select the "Record Macro" option. The software will begin recording your actions, and a small "Record" window will appear.
-
5
Complete the steps that you want to automate. Click the "Stop Recording" button when you are finished with all of the steps.
-
6
Type a descriptive name in the "Macro name" text box. Choose how you want to save the macro. If you want the macro to be global, save it under the "My Macros" section. If you want it to be used only with the current spreadsheet, save it under the spreadsheet's name.
-
7
Click the "Save" button.
-
1
References
Resources
- Photo Credit Burke/Triolo Productions/Brand X Pictures/Getty Images
