PDA

View Full Version : Automatically Enable Macros When Opening Database


Pam in TX
06-10-2009, 09:45 AM
We have a database that we create and then upload to the campus servers in our district for them to use and populate additional information.

They seem to always forget to click on the "Security Warning" in the ribbon... Is there something we can do so that when the database is opened all macros are enabled? Even if it has to be a BIG button in the middle of the screen to remind them...


Thanks in advance....
john3j
06-10-2009, 10:01 AM
I found this thread on the internet. Doesnt look good though.

http://www.ozgrid.com/forum/showthread.php?t=16599
OBP
06-10-2009, 10:03 AM
Have alook at this article about 2/3 of the way down the page
http://www.access.qbuilt.com/html/vba5.html
As it says setting the Certificate is the best option.
CreganTur
06-10-2009, 11:10 AM
The only other option is to have every user go into their security settings and change them to always allow. Not a great option :(
Pam in TX
06-10-2009, 11:24 AM
The only other option is to have every user go into their security settings and change them to always allow. Not a great option :(

I know they won't do that........
CreganTur
06-10-2009, 11:33 AM
I know they won't do that........

They would if you told them to:*)