Disable macro security with vba? reg-file?

  • Thread starter Thread starter Jesper F
  • Start date Start date
J

Jesper F

I have an app that runs on a total of 50-60 machines in four offices.
The IT-staff on those locations helps me with installs but they are spending
much time instructing users how to disable macro security. The app won't run
properly until that's done.
Is it possible to automatically disable macro security with vba or some
change to the registration database?

/ Jesper
 
Hi,
here 2 keys you need to set:

Root:
Local Machine
Key:
Local Machine Software\Microsoft\Office\11.0\Access\Security
Name:
level
Value
#00000001

Root:
Local Machine
Key:
Local Machine SOFTWARE\Microsoft\Jet\4.0\Engines
Name:
SandBoxMode
Value
#00000002

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
here 2 keys you need to set:
Root:
Local Machine
Key:
Local Machine Software\Microsoft\Office\11.0\Access\Security
Name:
level
Value
#00000001

Root:
Local Machine
Key:
Local Machine SOFTWARE\Microsoft\Jet\4.0\Engines
Name:
SandBoxMode
Value
#00000002
Click to expand...

That sounds good Alex. Are these the only two keys I need to set?
Will it cause problems for the user when setting these?
Can I do it from the db-file?
Thanks.

/ Jesper
 
Hi,
That sounds good Alex. Are these the only two keys I need to set?
Click to expand...

yes. Are you using 2003 or 2007? in 2007 you can also specify trusted
location
Will it cause problems for the user when setting these?
Can I do it from the db-file?
Click to expand...

Not sure you can, if macro security is set to high - then you can't run code
to update registry

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
Back
Top