Just to add to what Steve said!

If the security level was high, your macro would never run
since it would be disabled upon opening!

Dan E

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