To record a macro in LibreOffice Calc, the correct method is:

  1. Open LibreOffice Calc.
  1. In the top menu, go to Tools → Macros → Record Macro.
  1. A small “Record Macro” window appears; now perform all the actions you want the macro to automate (typing, formatting, etc.).
  1. When you’re finished, click Stop Recording in that window.
  1. In the dialog that appears, enter a name for the macro, choose where to store it (for example, “My Macros → Standard”), then click Save.

So if you’re looking at multiple-choice options, the correct one will be the option that describes:

Tools → Macros → Record Macro → perform actions → Stop Recording → name and save the macro.

(If macro recording doesn’t appear in the Macros menu, it first has to be enabled under Tools → Options → LibreOffice → Advanced → Enable macro recording.)

Mini breakdown (Quick Scoop style)

  • Menu path to start recording
    • Tools → Macros → Record Macro.
  • What you do while recording
    • Carry out the exact steps you want to automate (like formatting, typing values, sorting, etc.).
  • How you finish and save
    • Click Stop Recording, give the macro a name, choose its storage location, and save.

Information gathered from public forums or data available on the internet and portrayed here.