Skip to main content

Excel 2010 – Adjusting Trusted Publisher’s and Macro/Visual Basic Scripting

· One min read
  1. Open Excel 2010
  2. Click File
  3. Click Options
  4. Click on Trust Center
  5. Click Trust Center Setting
  6. Click Macro Settings
  7. Check – Enable All macros (not recommended; potentially dangerous code can run)
  8. Check Trust Access to the VBA project object model check box
  9. Click Ok
  10. Restart Excel 2010