Macros security

C

Chi

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
 
J

Jim Thomlinson

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

Homey

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.

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

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

Top