Need help creating VBA procedure for Open event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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