Macro to change security level

[Michael Miazga]

Is it possible to write a macro to automatically run when the spreadsheet is
opened which sets the security level to medium, so that the macros in a
spreadsheet will be able to be run? Also can the macro hit the enable
macros button for a excel install already set to medium? I don't want to
have to talk my users through resetting thier security settings..

 

[Tom Ogilvy]

Allowing a macro to change the security setting would defeat the purpose of
having a security setting. So, no, you can't do that with macro's contained
in the workbook being opened.

Regards,
Tom Ogilvy

 

[Michael Miazga]

Thanks, I figured so much, thought maybe there was a workaround.