Need help creating VBA procedure for Open event
 

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.

Need help creating VBA procedure for Open event
 

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.

Need help creating VBA procedure for Open event
 

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.