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

You have one response to your followup in .excel.



Celtic_Avenger wrote:

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_Avenger

--
Celtic_Avenger
------------------------------------------------------------------------
Celtic_Avenger's Profile: http://www.excelforum.com/member.php...o&userid=14101
View this thread: http://www.excelforum.com/showthread...hreadid=273920

--

Dave Peterson