I need to create a VBA procedure for the Open event of a workbook that will
check to see if the macro security level is set to High, and if so, display a
message advising the user to change the macro security level to Medium.

Being a novice to VBA, can someone please show me how to write such a
procedure? Thanks.

Mike,

Thanks for the link! However, rather than displaying the current macro
security level, I just need to determine if it is not set to Medium, and if
so, set it to Medium.

Can you help?

Thanks again,
Bob


"Mike H" wrote:

Have a look here

http://www.microsoft.com/office/comm...ad6&sloc=en-us

Mike

"Bob" wrote:

I need to create a VBA procedure for the Open event of a workbook that will
check to see if the macro security level is set to High, and if so, display a
message advising the user to change the macro security level to Medium.

Being a novice to VBA, can someone please show me how to write such a
procedure? Thanks.

Have a look here

http://www.microsoft.com/office/comm...ad6&sloc=en-us

Mike

"Bob" wrote:

I need to create a VBA procedure for the Open event of a workbook that will
check to see if the macro security level is set to High, and if so, display a
message advising the user to change the macro security level to Medium.

Being a novice to VBA, can someone please show me how to write such a
procedure? Thanks.