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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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---
 
I just answered my own question:
Tools > Options > Edit > Uncheck "Ask to update automatic links"

Hope others benefit from my buffoonery.
 
Back
Top