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

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---
 
R

ryguy7272

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

Hope others benefit from my buffoonery.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top