Results 1 to 2 of 2
  1. #1
    LindaRuble is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    63

    Capture an “Enable Macros” warning event

    Hello,

    Sometimes when a program is launched on another computer, it is not seen as a Trusted Source and an "Enable Macros" warning pops up.
    Normally that is not a big problem, however, if you are using a Form that is POP-UP and Modal, then that Form will not allow you to get past it to get to the yellow "Enable Macros" dialogue box. Eventually you click on something and beat it into submission until it closes down or make to do what you want.

    I would like to handle this situation more gracefully

    I was thinking of capturing the "Enable Macros" error event and directing the user to a non-modal form (that does not get in the way) with instructions to click on the yellow "Enable Macros" dialogue box to enable the macros.

    Is there a way to capture the "Enable Macros" error event? And if so, how?

    Any help would be appreciated.



    Thanks

    Linda

  2. #2
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    I was thinking about this the other day, I was thinking of creating a batch file to change that setting in registry.

    But for access 2010, that trusted locations nonsense is getting in the way

    http://social.technet.microsoft.com/...-9359ff08302d/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Disable security warning to "enable content"?
    By Heatshiver in forum Security
    Replies: 2
    Last Post: 02-03-2012, 02:26 PM
  2. How do I capture Access DB exit event
    By jscriptor09 in forum Access
    Replies: 3
    Last Post: 09-21-2011, 09:45 AM
  3. Replies: 5
    Last Post: 01-15-2011, 01:35 AM
  4. Force user to enable macros
    By tuna in forum Security
    Replies: 1
    Last Post: 05-09-2010, 04:04 AM
  5. Capture 2nd Value in an unbound Combo.
    By sesproul in forum Forms
    Replies: 5
    Last Post: 04-30-2010, 02:07 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums