Showing results for 
Search instead for 
Did you mean: 

Detect Developer Macro settings for VBA project object model

Hi. I have a VI that makes an excel spreadsheet and runs a few macros. My users need to change their excel settings to trust access to the vba project object model. Is there a way to detect these settings in excel ahead of time?  This way, I could warn a user before running the macros that there will be an error.  Thanks.
0 Kudos
Message 1 of 2

There's registry keys you can check, and I believe the Application.AutomationSecurity class can also provide that information, as discussed here.



0 Kudos
Message 2 of 2