PK

kind of Catch 22 really ... if the security level is high you don't get to
run a macro, if it's medium you have to confirm that you do. In either
case, you can't change the security level. That would rather defeat the
object of having a security level and be a hackers dream.

Regards

Trevor


"PK" wrote in message
...
Please help! I am using VBA in Excel XP with Windows 2000.

When you go to <Tools <Options then click the "Security"
tab and then click the "Macro Security" button, you are
presented with three levels of security for opening files.
High, Medium, and Low.

Using an "Auto_Open" macro or other method, is there a way
to programmatically drop someone's security level
from "High" to "Medium" or even to "Low"?

Your example code is most appreciated. Thanks in advance.