How to create a Macro

1. Navigate to Developer > Create Macro
   
2. In the dialog that appears, enter a name and a description for the macro, then click Create.
   
3. Enter the code in the VBA editor.
   
4. Click Save.
   

Sample macro codes to get started with:

 Hide and unhide row   

Send emails based on the change in cell value

Workbook open event and new sheet create event
   

1. REM ThisWorkbook Module
2. 
   
3. Private Sub Workbook_Open()
4. Msgbox("I am a open event ",-1,"Welcome back!")
5. End Sub
6. Private Sub Workbook_NewSheet(ByVal sh As Object)
7. Msgbox("I am a new sheet event , You have created a sheet !  ",-1," Name it ")
8. End Sub

Worksheet change event
   

How to record a macro

1. Go to Developer > Record Macros 
   
2. Enter a name and a description in the input field.
   
3. You can check or uncheck Use Relative Reference as needed.
   
4. Click Record.
   
5. To stop recording, click on the Stop icon 
6. Click View Code to view the recorded macro in the VBA editor or click Macro List to view all the macros in the spreadsheet.
   

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.