LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How do I disable the Excel Macro Security Warning

I tried setting the DisplayAlerts to false, but the popup keeps appearing when I open an excel file with a macro from my vi. How can I either disable this or programmatically select the option to allow macros?
0 Kudos
Message 1 of 3
(3,895 Views)
Go into Excel.  Go Tools >>  Macros >> Security.  Select the lowest setting for Macro security.  They say it is not recommended, but it avoids the annoying popup everytime you want to open an Excel sheet that has macros.  As long as you aren't prone to opening Excel files from unknown sources or other places you shouldn't trust, you should be fine.
0 Kudos
Message 2 of 3
(3,893 Views)
I know how to do that part, but I'm going to be deploying onto other machines, so I need to be able to do this through code.
0 Kudos
Message 3 of 3
(3,888 Views)