How to set macro security levet to LOW using VBA? 1

[surotkin]

Hello everyone,
I am wondering if it is possible to use VBA to set macro security levet to LOW (TOOLS->MACRO->SECURITY).

Does anybody have an idea?

Thanks.
surotkin

 

[easyit]

Well,

That would be a breach of security, wouldn't it? The "low" is to prevent VBA from being executed in the first place...


EasyIT

 

[Crowley16]

edit the registry key...

HKLM\SOFTWARE\Microsoft\Office\11.0\Access\Security\Level = 1

--------------------
Procrastinate Now!

 

[surotkin]

Hi Crowley16,
thanks a lot.
It works (even though I am getting a security message of unsafe expressions).
Just one detail, on my computer I did not find this key under HKLM, but I found it under HKEY_CURRENT_USER.

Thanks.
surotkin