locked
Disable Macros doesn't work right RRS feed

  • Question

  • I have recently purchased a new machine with windows 10 and access 2016.  When following a hyperlink, I get the standard security message.  I went to the trust center to enable all macros, but it didn't disable the message.  What am I doing wrong?

    Monday, November 2, 2020 3:34 PM

Answers

  • Thanks to all for your responses.  I finally found this link which solved the problem.

    https://www.technipages.com/disable-hyperlinks-can-be-harmful-to-your-computer-and-data-message

    • Marked as answer by tkosel Tuesday, November 3, 2020 9:53 PM
    Tuesday, November 3, 2020 9:52 PM

All replies

  • https://support.microsoft.com/en-us/office/enable-or-disable-macros-in-office-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6

    i hope answer the question  please vote if issue resolve

    • Proposed as answer by sameer degya Monday, November 2, 2020 7:24 PM
    Monday, November 2, 2020 5:09 PM
  • Thanks for your response.  However, as I previously said, I have used the trust center to enable all macros and it didn't work.
    Monday, November 2, 2020 10:34 PM
  • Using Application.FollowHyperlink URL doesn't trigger macro warnings whatever your macro settings.

    What exactly is the code you used and the error/security message you get?

    Tuesday, November 3, 2020 1:04 AM
  • These are standard security messages and the Trust Center cannot circumvent them.

    How exactly are you opening the links?  These are just hyperlinks in a form?  If so, then the answer can be found at https://docs.microsoft.com/en-us/office365/troubleshoot/administration/enable-disable-hyperlink-warning


    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Tuesday, November 3, 2020 1:32 AM
  • Daniel,

    My code appears below.  This worked fine in previous versions of access.

    Me.DocumentHyperLink = DLookup("[DocumentHyperLink]", "Training_Documents_Parent", "[Training_Doc_ID] = " & "'" & Me.Training_Doc_ID & "'")
        DoCmd.SetWarnings False
        Application.FollowHyperlink Me.DocumentHyperLink, , True
        DoCmd.SetWarnings True

    Error message is below

    Tuesday, November 3, 2020 3:56 PM
  • Thanks to all for your responses.  I finally found this link which solved the problem.

    https://www.technipages.com/disable-hyperlinks-can-be-harmful-to-your-computer-and-data-message

    • Marked as answer by tkosel Tuesday, November 3, 2020 9:53 PM
    Tuesday, November 3, 2020 9:52 PM