My Profile Photo

luke.geek.nz


An IT Engineer with a love for all things IT including (but not limited to), Microsoft Azure, Automation and Service Management!


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

  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
comments powered by Disqus