How do I programmatically set macro security to Low ?

[Jim Andersen]

I have this 2003 Run-time app. It keeps giving the warning.

How do I let the user switch macro security to Low ? He doesn't have a
Tools-menuitem....

I found this:
http://groups.google.dk/groups?hl=da...419%40pd7tw3no

but I can't find that setting in my registry (developer PC or test PC).

thx
/jim

['69 Camaro]

Hi, Jim.

You can change the Windows Registry manually, or you can write VBA code to
open the Macro Security dialog window for the user to make the change
manually in the Access runtime application. An explanation of both methods,
including source code to access the built-in menu, can be found here:

http://www.Access.QBuilt.com/html/vb...SetMacroSecLvl

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
"Jim Andersen" <jimVÆÆ[e-mail]> wrote in message
news:41***********************@news.sunsite.dk...

I have this 2003 Run-time app. It keeps giving the warning.

How do I let the user switch macro security to Low ? He doesn't have a
Tools-menuitem....

I found this:
http://groups.google.dk/groups?hl=da...419%40pd7tw3no
but I can't find that setting in my registry (developer PC or test PC).

thx
/jim

[Jim Andersen]

'69 Camaro wrote:

http://www.Access.QBuilt.com/html/vb...SetMacroSecLvl

Thank you so much for a quick and 100% correct solution to my problem.

/jim

['69 Camaro]

You're welcome! Glad it helped.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
"Jim Andersen" <jimVÆÆ[e-mail]> wrote in message
news:41***********************@news.sunsite.dk...

'69 Camaro wrote:

http://www.Access.QBuilt.com/html/vb...SetMacroSecLvl

Thank you so much for a quick and 100% correct solution to my problem.

/jim