"trust access to visual basic project" option

[Arthur]

The "trust access to visual basic project" option in tools->macro->security
is grayed out. How can I turn that option on. I am the admin on that
desktop. Thank you for any feedback.

 

[Nikos Yannacopoulos]

Arthur,

This is probably the result of a policy restriction on your Windows
setup.... yet, it's easy to "hack" it by changing a key value in the
registry. Locate this key:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security

and change the value of the Level to 1 (dword:00000001)

HTH,
Nikos

 

[Nikos Yannacopoulos]

I forgot to mention, the 11.0 part in the key path below:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security

assumes that you are using Office2K3; it will be a smaller number if you
have an older version. If you find multiple, it's the highest number
that refers to your active (presumably, the latest) version.

Nikos