PDA

View Full Version : How can I disable the links and query alerts



slang
05-06-2008, 11:55 AM
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.:help

matthewspatrick
05-08-2008, 06:10 AM
Have you tried:


Application.DisplayAlerts = False


?

slang
05-08-2008, 08:23 AM
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.....

slang
05-11-2008, 04:11 PM
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?