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

"Michael Miazga" wrote in message
...
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..

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


"Tom Ogilvy" wrote in message
...
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" wrote in message
...
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..