Forum Discussion
Enabling macro in trust center
Under the Trusted Center, Macro Settings and Macro Settings dialog the “Enable VBA Macros” has been selected along with “Enable Excel 4.0 macros when VBA macros are enabled” has selected. Along with ...
Try the below on the possible issue and fix:
- Trust Access to the VBA Project Object Model
Even if macros are enabled, Excel may block access to the VBA engine.
- Go to File > Options > Trust Center > Trust Center Settings
- Click Macro Settings
- Check: “Trust access to the VBA project object model”
- Add Your Folder to Trusted Locations
If your workbook is stored in a folder that Excel doesn’t trust, macros may silently fail.
- Go to Trust Center > Trusted Locations
- Check: “Allow Trusted Locations on my network”
- Click Add new location
- Browse to the folder where your workbook and Personal.XLSB are stored
- Check: “Subfolders of this location are also trusted”
- Confirm File Format
Make sure your workbook is saved as a Macro-Enabled Workbook (.xlsm).
- Go to File > Save As
- Choose Excel Macro-Enabled Workbook (*.xlsm)
- Check for Conflicting Add-ins or Startup Files
- Go to File > Options > Add-ins
- Disable any non-essential add-ins
- Restart Excel and test again
- Open Personal.XLSB Correctly
Make sure Personal.XLSB is loaded when Excel starts:
- Open Excel
- Press Alt + F11 to open the VBA editor
- Confirm Personal.XLSB appears in the Project Explorer
- If not, manually open it from:
- C:\Users\<YourUsername>\AppData\Roaming\Microsoft\Excel\XLSTART