R
ryguy7272
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 Bruin’s code (GREAT STUFF RON):
http://www.rondebruin.nl/copy3.htm
Sub Basic_Example_1()
‘etc…
End Sub
I’m getting the standard message:
‘This workbooks contains links to other data sources’
Does anyone know how to turn this off? I don’t want to click ‘Don’t Update’
hundreds of times.
TIA,
Ryan---
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 Bruin’s code (GREAT STUFF RON):
http://www.rondebruin.nl/copy3.htm
Sub Basic_Example_1()
‘etc…
End Sub
I’m getting the standard message:
‘This workbooks contains links to other data sources’
Does anyone know how to turn this off? I don’t want to click ‘Don’t Update’
hundreds of times.
TIA,
Ryan---