Detect Developer Macro settings for VBA project object model

[jochoco]

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.

[smercurio_fc]

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

Remember: