Please tell me if there a solution for the following requirement.
I need a macro (excel) which can change security of the macro (tools>Macro>security>) to Low & High by it self. Running macro will change the security option. Even though your security is set to High this will runs and change it to Low, i.e.
1) macros hard to (not impossible) run when it set to high.
2) but most of Excel options can change/lock/ fix with macros Eg. Can stop "save as function" or limiting other menu options
Asking this Q on behalf of a friend. Looking forward to hear from you guys. Thanks!