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

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

i think on your machine you can do this registy entry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\ Excel\Security\Level

set value = 2. this a dword item.

once this set all users forced to medium. no user can change once you do
this. so you need to remove this entry if you want change even your seting.

"Chi" wrote in message
...
| 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
|