[RESOLVED] How to set macro security [Word/Excel]

[ashokkumard]

Hi

Is it possible to set the macro security always in low level through code? By executing the code automatically the security level option to be in low level.

[Hack]

I don't believe so.

Why would be want to change someone's macro security anyway?

[westconn1]

you could look at the registry key for security level

[anhn]

I don't think you can use your code to change Macro Security setting.
If you can do that then it defeats the purpose of Macro Security.

[ashokkumard]

Hi all

The options availble in macro security settings are very high, high, medium & low in 2003. I have some set of VBA code and want to execute in users system. There the macro security setting ll be high (default) and not able to execute my code until the user select the option low. So if there is any code to alter the seciruty level means then it ll be easy for us.

[RobDog888]

You do not alter the security settings as reasons mentioned. The way you do it is by signing your macro code with a Digital Certificate/Signature.

http://www.vbforums.com/showthread.php?t=402030

Another way is to write an AddIn and have the users install it.

[RobDog888]

Im sorry but posting a "hack" like that isnt within our policies. Bypassing security measures is an AUP violation.

There is a proper way to do it so its within the users acceptance and a hackers way to do it which is what you posted. Sorry.