If you can change the security level then it is not very secure. For that
reason you can not modify the security setting.

What you can do is to set up a dummy sheet that contains instructions on
enabling macros. At the on-close event you unhide this sheet and hide all
others. At the on open you do the reverse. This way if the user has macros
enabled they see that sheet as intended. If macros are not enabled then they
only see your message about macros.

--
HTH...

Jim Thomlinson


"Chi" wrote:

Hi,

I have an Excel file that has some codes with it. It runs fine with my
computer that has 2003 version and the security level is MEDIUM by default
when I sign it. The problem is that when my friend signs in my computer, the
Macros security level switch to high. Usually she got the warning message
about the security level and able to see a part of hidden information.

Is there a way that I can force the macros security level at MEDIUM level
regardless of who signs in?

Thanks
Chi