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

--
Celtic_Avenge
-----------------------------------------------------------------------
Celtic_Avenger's Profile: http://www.excelforum.com/member.php...fo&userid=1410
View this thread: http://www.excelforum.com/showthread.php?threadid=27392