Archive of Mr Excel Message Board
Back to Links in Excel archive index
Back to archive home
Update Links Code
Posted by Paul Magruder on April 17, 2001 6:46 AM
I would like to remove the "Update Links?" message when I open a certian workbook. I do not want to update the links. I am not sure how to write the code.
I would think it would be in a private sub under workbook open? ActiveWorkbook.Select , UpdateLinks:=0
dosen't work......
Thanks in advance
Paul
Re: Update Links Code - untested guess
Posted by mseyf on April 17, 2001 10:33 AM
you could try:
Application.AskToUpdateLinks = False
you may want to set back to true when closing the file.
HTH
Mark
Re: Update Links Code - untested guess
Posted by Dave Hawley on April 17, 2001 3:48 PM
Hi Paul
You wont be able to do this from within the Workbook itself as the Links message appears before any Events fire.
You would need to open the Workbook from within another workbook like:
Workbooks.Open "C:\MyDocuments\Book1.xls", UpdateLinks:=0
Dave
OzGrid Business Applications
Re: Thanks Dave
Posted by Paul Magruder on April 18, 2001 5:11 AM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.