Record a macro

Record a macro

To record a macro:

  1. Click Tools > VBA Macros > Record.

  2. Name the macro and continue recording. Note that the macro name can only consist of alphabets, numbers and underscore characters.

  3. Click on the box near Use Relative Reference if you want the cell referencing in the macro to be relative (A1, for instance) and not absolute* ($A$1 for instance).

  4. Make the changes that you wish to be recorded in the macro. 

  5. Click on Stop Recording *image* icon near the notification to stop the process. You can also edit the recorded macro using the VBA editor.


Absolute referencing - The cells are referenced $Column_Number$Cell_Number, meaning the macro is executed in the same cells used when recording the macro.

Relative referencing - The cells are referenced without the "$" constraint, meaning the macro is executed with cells relative from where the macro is executed.

You can choose if you need absolute or relative referencing from the popup indicating that the macro is being recorded too.

    • Related Articles

    • What is a Macro?

      Macros are sequences of actions that you want to automate. You can do this by creating a VBA macro or record a macro. 

    • Create a VBA macro in sheet

      To create a macro: Click Tools > VBA Macros > Create.  The Create Macros menu is displayed. Name the macro that you wish to create. You can also describe the functioning of the macro. Note that the macro name can only consist of alphabets, numbers ...

    • Run a macro in a sheet

      To run a macro: Click Tools > VBA Macros > Manage > Run the macro you want from the list of macros you've created for the sheet. You can also assign a macro to a button and run the macro just by clicking the button. ​

    • How many emails, tasks and field updates can I configure in a Macro?

      You can add 1 email, 3 tasks, and 3 field updates in a Macro.

    • Why am I not able to see the 'Run Macro' button?

      The Macros features and the 'Run Macro' button will be available only if you have all the three profile permissions mentioned below: Mass Email Mass Update Create ActivitiesRelated Topic Managing Profiles