Stop Warning Message?

C

Celtic_Avenger

Hi peeps.............


I have used the following code in the Workbook_Open() VBA page

Application.IgnoreRemoteRequests = True

When I then open the workbook I get a popup message saying

"Existing Remote Links Will Be Terminated"

with a "OK" and a "Cancel" options..........

I am happy for this on each occasion the work book opens. I have used

Application.IgnoreRemoteRequests = False

when the workbook closes, to turn this option off.


Is there a way to stop the popup warning from being displayed.


Celtic_Avenge
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

terminating remote links? 1
2 Files Open In 2 Instances Of Excel 1
File Download - Security Warning 5
Pop up warning message! 1
Stop sheet showing when Using Datapig's Force Users to enable macr 1
How to stop Macro warning on opening workbbok 3
How to stop the popup warning window when clicking on a hyperlink 1
Stopping warning message 2

Top