Skip to main content
Question

How can I disable macros in Excel in the package level?

  • February 17, 2017
  • 2 replies
  • 19 views

Forum|alt.badge.img+3

Can someone please help me to disable macros through the package level. The checkbox should be grayed out. Users cannot change the settings from prefereances. It has to disable. please help me how I can do this from the package level ? Or if you can provide any script to disable macro that helps me as well.

2 replies

ralphaelhollins
Forum|alt.badge.img+3

After 3 years we are in the same boat. I would like to see the code to disable or grey it out.


luke_apnic
Forum|alt.badge.img
  • New Contributor
  • August 25, 2021
defaults write com.microsoft.office VisualBasicMacroExecutionState -string DisabledWithoutWarnings