Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Recording a Macro

Office can record commands executed with the keyboard and mouse in Writer and Calc

  1. Open the document for which you want to record a macro.

  2. Choose Tools - Macros - Record Macro.

If Tools - Macros - Record Macro menu item is missing, make sure that macro recording feature is enabled in Tools - Options - Office - Advanced.

You will see the small Recording dialogue box with just one button called Stop Recording.

  1. Perform the actions you want to be recorded in the document.

Press the Escape key to deselect an object, as the macro recorder currently does not record this action by mouse click.

  1. Click Stop Recording.

The Macro dialogue box appears, in which you can save and run the macro.
If you want to abort the recording without saving a macro, click the Close button of the Recording dialogue box.

  1. To save the macro, first select the object where you want the macro to be saved in the Save macro in list box.

  2. If you want the macro to be saved into a new library or module, click the New Library or New Module button and enter a name for the library or module.

  3. Enter a name for the new macro in the Macro name text box. Do not use Basic keywords as a name.

  4. Click Save.

Limitations of the macro recorder

The following actions are not recorded:

  • Opening of windows is not recorded.
  • Actions carried out in another window than where the recorder was started are not recorded.
  • Window switching is not recorded.
  • Actions that are not related to the document content are not recorded. For example, changes made in the Options dialogue box, macro organiser, customising.
  • Selections are recorded only if they are done by using the keyboard (cursor travelling), but not when the mouse is used.
  • The macro recorder works only in Calc and Writer.