Purchase
How can we help you?

Create a macro

Application: Spreadsheet Home Edition macOS

You can create a macro in one of the following ways:

•Record a sequence of actions that a macro should consist of.

•Enter the macro code manually.

To record a macro, do the following:

1.Start recording in one of the following ways:

•On the Macros tab, click t_macros_rec_icon Record macro (beta).

•When working in macOS, select Tools > Macros > Record macro (beta) command from the command menu.

•If there is at least one macro in the document, click side_panel_macro Macros on the Sidebar. In the Macros pane, click the side_panel_macro_expand button to the right of the New macro button. In the drop-down list, select Record macro (beta).

2.Perform a sequence of actions that a macro should consist of.

In the current version of the application, not all user actions are available for recording. When you perform an action that cannot be recorded, the message “Action cannot be recorded” pops up on the screen.

3.Complete the recording in one of the following ways:

•On the Macros tab, click t_macros_stop_rec_icon Stop recording macro command.

•When working in macOS, select Tools > Macros > Stop recording macro command from the command menu.

•If there is at least one macro in the document, click side_panel_macro Macros on the Sidebar. In the Macros pane, click the side_panel_macro_expand button to the right of the New macro button. In the drop-down list, select Stop recording macro.

•On the Status bar, click t_macros_stop_rec_icon Stop recording.

4.In the opened dialog box, specify the macro name and click OK.

If the macros has been successfully saved, the following pop-up message will be displayed on the screen: “"Macro_name" macro saved”.

To enter the code of a macro manually:

1.Create a new macro using one of the following methods:

•On the Macros tab, click t_macros_editor_icon Macro editor. When working in macOS, you can also run the Tools > Macros > Macro editor command from the command menu. In the Macro editor window, click macros_add_script_icon.

•If there is at least one macro in the document, click side_panel_macro Macros on the Sidebar. In the Macros pane, click New macro.

2.Enter a name for the macro or leave the default name. To save the name, press Enter or click anywhere in the Macro editor.

3.Enter the code of the macro.

The new macro will be saved automatically.

When you add the first macro to your document, the side_panel_macro Macros button appears on the Sidebar. This button is displayed as long as there is at least one macro in the document.

Click side_panel_macro Macros to open Macros pane.

To close the Macros pane, click the side_panel_macro_close button at the top of the pane, or click side_panel_macro Macros button on the Sidebar again.

 

Was this helpful?
Yes
No
Next
Find a macro