Disabling Macros With VBA After Enabling

[animas]

When user enables macros during workbook open, is there any vba or event that immediately disables macro for that workbook?

This way I need to ensure vba won't run for that workbook even if macro is enabled.

 

[shg]

If you mean when a user opens a workbook via the user interface, with no other workbooks open, then no way that I know of.

If the workbook is opened programmatically, then you can set Application.AutomationSecurity to msoAutomationSecurityForceDisable before opening the file.

 

[animas]

I created a global named range in a worksheet for disabling macros. What I need is when user will select it's value "YES" no macro should work. Any suggestion on these?

 

[shg]

You'd have to code all the macros to test that cell and abort if appropriate.

 

[animas]

can u give a simple example of the codes?