Be the first user to complete this post

  • 0
 Add to List

How to Enable Macro in Excel

Before we proceed, first and foremost thing to do is Enable the Macro in your Excel

Main Menu -> Excel Options

Enable Macro in Excel-1
Enable Macro in Excel-1

Trust Center->Trust Center Setting

Enable Macro in Excel-Trust Center Settings
Enable Macro in Excel-Trust Center Settings

Macro Setting

  • Select the “Enable all macros”-
  • Developers Macro Settings-> Select the “Trust access to the VBA project Object Model”

Hit OK

Enable Macro in Excel-3
Enable Macro in Excel-3

Also Read:

  1. VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order
  2. Add Tools to Quick Access Tool Bar(Excel Top Bar)
  3. Message Boxes in VBA Excel (Msgbox)
  4. VBA-Excel : 3D-Ranges – FillAcrossSheets Method
  5. VBA-Excel: Create Dynamic or Run-time WorkSheets using Macro.