By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

How do I programmatically set macro security to Low ?

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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ÆÆK@officeconsult.dk> 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

Nov 13 '05 #2

P: n/a
'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
Nov 13 '05 #3

P: n/a
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ÆÆK@officeconsult.dk> 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

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.