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 this I am using the Personal.XLSB file to hold the macros. I have attempted multiple times to enable the macros within the workbook with no success. I first open the Personal file then the workbook of interest. Upon opening I do not receive a header to enable the macros. I then attempt to run a macro and continuously receive the error message that I must enable the macro and reopen the workbook.
1 Reply
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