I have Excel file that is linked to Access Database. Everytime the user opens the file, there is pop up message that warns the user we there to enable the macro or to disable it. I want to force the user to enable the macro or even better if I can make disappear this warning and automatically enable the macro. See attached for more details. Thanks.
Last edited by karinos57; 03-04-2009 at 06:15 PM.
You can't keep the box from populating...this is a security procedure built in to ensure that a user understands that a macro exists - as some macros may be malicious in their intent. But...you can make them have to enable the macro in order to use the spreadsheet....check out this link.
http://vbaexpress.com/kb/getarticle.php?kb_id=379
I help because of the Pavlovian dog that resides in the inner me...so if you are happy with the results, please add to my reputation. It helps keep me motivated!
Please mark your threads as Solved once it is solved. Check the FAQ's to see how.
Thanks. That helps.
Glad to help....please make sure you mark the post as solved. See the FAQs link below for help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks