In Excel, the Visual Basic editor and Macros can be accessed on the Developer tab. If you do not currently see this tab in Excel, you will need to enable it using the following steps:

  1. Click on File > Options
  2. Click on Customize Ribbon, then check the box next to Developer under Main Tabs
  3. Click on Trust Center > Trust Center Settings
  4. Under Macro Settings, select “Enable all macros”
  5. Under Developer Macro Settings, check the box next to “Trust access to the VBA project object model”
  6. Click on OK
  7. The Developer tab will now be available

Please ensure you are running Windows Defender or similar security to ensure you are protected while macros are enabled. Click here for more information.

Advertisements