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