Links to Other Data Sources, Can't Turn off Application.DisplayAle
 

I have used Application.DisplayAlerts = False and Application.DisplayAlerts =
Many times in the past. However, I have never used this when opening and
copying data from workbooks that contain links to other workbooks. I just
tried to use some of Ron de Bruins code (GREAT STUFF RON):

http://www.rondebruin.nl/copy3.htm

Sub Basic_Example_1()
€˜etc€¦
End Sub

Im getting the standard message:
€˜This workbooks contains links to other data sources

Does anyone know how to turn this off? I dont want to click €˜Dont Update
hundreds of times.

TIA,
Ryan---

--
RyGuy

Links to Other Data Sources, Can't Turn off Application.DisplayAle
 

I just answered my own question:
Tools Options Edit Uncheck "Ask to update automatic links"

Hope others benefit from my buffoonery.


--
RyGuy


"ryguy7272" wrote:

I have used Application.DisplayAlerts = False and Application.DisplayAlerts =
Many times in the past. However, I have never used this when opening and
copying data from workbooks that contain links to other workbooks. I just
tried to use some of Ron de Bruins code (GREAT STUFF RON):

http://www.rondebruin.nl/copy3.htm

Sub Basic_Example_1()
€˜etc€¦
End Sub

Im getting the standard message:
€˜This workbooks contains links to other data sources

Does anyone know how to turn this off? I dont want to click €˜Dont Update
hundreds of times.

TIA,
Ryan---

--
RyGuy