How to enable macro setting in VBA | Satish Bhatlawande
Enable the Macros
1 Click on Macro Security, on the Developer Ribbon.
2 Select the option to Enable all macros.
3 Check "Trust access to the VBA object model" checkbox. This will let you run macros without any annoying security warnings
Open the VBA Editor
1. Method I: Click on the Visual Basic button on the Developer tab.
2. Method II: Click on the View code button on the Developer tab.
3. Method III: Use the shortcut keys combination of Alt + F11.
4. Method IV : Right click on sheet name and select “View code”
Identify the VBA editor elements
The left side area in the VBA window is called as VBA Project window. This shows a list of all the objects in the current project.
One Excel workbook is displayed by default and this workbook contains all the macros.
This window also displays one or more Excel sheets depending on the version of Excel being used.