Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

external link confirm dialog box...

Posted by rm on January 02, 2002 4:04 PM

hello,

does anyone know vba code to always accept (same as pressing "yes") to dialog box asking to update external links referenced in sheet. I would like the workbook I am preparing to involve as little user intervention as necessary...thank you...rm

Re: external link confirm dialog box...

Posted by Rosencrantz on January 02, 2002 4:52 PM

If you want links to be updated automatically (i.e. the dialog box does not appear), go to tools>options>edit and de-select "ask to update automatic links".

If you want links to be updated when the workbook is opened (even if the dialog box appears and user selects "No"), put this in the workbook module :-

Private Sub Workbook_Open()
ThisWorkbook.UpdateLink _ Name:=ThisWorkbook.LinkSources
End Sub

Re: external link confirm dialog box...

Posted by rm on January 02, 2002 5:27 PM

thanks Rosencrantz for the goods...it's too bad that vba can't do this and it has to be done manually, because this workbook will always be "yes" to updating links (but may not be so with other workbooks opened)...so I wanted to make it easier for user...but I guess one little button click won't be so bad...rm

Re: external link confirm dialog box...

Posted by Rosencrantz on January 03, 2002 6:33 AM

Maybe it can be done, but if it can I don't know how. Perhaps you should post again. Sorry I can't help further.

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.