Need help creating VBA procedure for Open event

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook Open Event Procedure 1
Identifying Machine or Location When a Procedure is Run 6
Creating a procedure using VBA Code 3
set macro security level through VBA 4
Calling a procedure from another workbook 4
Return Excel's current security setting 2
Using VBA to open Excel , Auto_Open Procedure not running 2
Macro Security 1

Top