Macro to change security level

  • Thread starter Thread starter Michael Miazga
  • Start date Start date
M

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..
 
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
 
Back
Top