MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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

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

Posted by Paul Magruder on April 18, 2001 5:11 AM

Re: Thanks Dave

Thanks Dave