Consulting

Results 1 to 4 of 4

Thread: How can I disable the links and query alerts

  1. #1
    VBAX Regular
    Joined
    Apr 2008
    Posts
    97
    Location

    Question How can I disable the links and query alerts

    I have an application that has links to other sheets that open via code when needed and also queries from external data.
    How do I disable the user from seeing the ?cannot update links? and hide the ?enable automatic refresh? alerts.
    I want to make the default ?Enable Automatic Refresh?
    I assume I put this code in the ?workbook open? section?

    Thanks for your help.

  2. #2
    VBAX Expert
    Joined
    Jul 2004
    Location
    Wilmington, DE
    Posts
    600
    Location
    Have you tried:

    [VBA]
    Application.DisplayAlerts = False
    [/VBA]

    ?
    Regards,

    Patrick

    I wept for myself because I had no PivotTable.

    Then I met a man who had no AutoFilter.

    Microsoft MVP for Excel, 2007 & 2008

  3. #3
    VBAX Regular
    Joined
    Apr 2008
    Posts
    97
    Location
    That takes care of the "links" message but does not remove the "Query refresh" alert to enable automatic refresh.
    Is there a way to have this not display and have the setting default to "Automatic refresh"?

    Thanks.....

  4. #4
    VBAX Regular
    Joined
    Apr 2008
    Posts
    97
    Location
    Any ideas on how or if the external data query prompt can be bypassed through code?
    Maybe more details might help.
    I have a query that uses an external data range that is refreshed automatically when the user changes a cell value. Everything works fine but I would like to kill the "external data query" prompt when the workbook opens.

    Any Ideas?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •