Disable the automatic link message

dantb · Apr 4th, 2002, 11:31 AM

Does anyone know how to disable the (this workbook contains links to other workbook message)I would like the workbook to automaticaly accept "yes".I found this line below,but dont know if it is right or if it is where to put it. Thx Dan

Application.AskToUpdateLinks = False

willlobb · Apr 4th, 2002, 12:13 PM

does this message appear as soon as the spreadsheet is opened?
Will

dantb · Apr 4th, 2002, 12:20 PM

Yes, Exact message >>(The workbook you opened contains automatic links to information in anouther workbook. Do you want to update this workbook with changes made to the other workbook) Then it gives you a yes or no option. I have a Range in this book that is linked to the other book.

willlobb · Apr 4th, 2002, 12:22 PM

then create a macro called
Sub auto_open
and paste the line of code in this macro. if our code is right, then this should work
Will

dantb · Apr 4th, 2002, 12:30 PM

Ok thx for your help Will, have a good day ! Dan

willlobb · Apr 4th, 2002, 12:31 PM

did that work?
Will

dantb · Apr 4th, 2002, 12:35 PM

Works Great thanks, this is what I used.

Sub auto_open()
Application.AskToUpdateLinks = False
End Sub

nancyo · Apr 4th, 2002, 03:00 PM

OK - I have the same problem, but I DONT want to link the files. I tried the macro described and it didn't work. I tried in a module and this workbook. I copied exactly what was written by Dan, and a couple of variations. I feel like an idiot!! I've had much more complicated macros work, and this one is 3 lines! Help!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 11:31 AM	#1
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Does anyone know how to disable the (this workbook contains links to other workbook message)I would like the workbook to automaticaly accept "yes".I found this line below,but dont know if it is right or if it is where to put it. Thx Dan Application.AskToUpdateLinks = False

Apr 4th, 2002, 12:13 PM	#2
willlobb Board Regular Join Date: Mar 2002 Posts: 103	does this message appear as soon as the spreadsheet is opened? Will

Apr 4th, 2002, 12:20 PM	#3
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Yes, Exact message >>(The workbook you opened contains automatic links to information in anouther workbook. Do you want to update this workbook with changes made to the other workbook) Then it gives you a yes or no option. I have a Range in this book that is linked to the other book.

Apr 4th, 2002, 12:22 PM	#4
willlobb Board Regular Join Date: Mar 2002 Posts: 103	then create a macro called Sub auto_open and paste the line of code in this macro. if our code is right, then this should work Will

Apr 4th, 2002, 12:30 PM	#5
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Ok thx for your help Will, have a good day ! Dan

Apr 4th, 2002, 12:31 PM	#6
willlobb Board Regular Join Date: Mar 2002 Posts: 103	did that work? Will

Apr 4th, 2002, 12:35 PM	#7
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Works Great thanks, this is what I used. Sub auto_open() Application.AskToUpdateLinks = False End Sub

Apr 4th, 2002, 03:00 PM	#8
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	OK - I have the same problem, but I DONT want to link the files. I tried the macro described and it didn't work. I tried in a module and this workbook. I copied exactly what was written by Dan, and a couple of variations. I feel like an idiot!! I've had much more complicated macros work, and this one is 3 lines! Help!