suppress popup message

  • Thread starter Thread starter walt
  • Start date Start date
W

walt

If I open a specific workbook i get the following message:

"The workbook you opened contains automatic links to information in another
workbook. do you want to update this workbook with changes made to the other
workbook?"

I ALWAYS answer that with "no". The open-routine is done by a macro and
would like answer this question by default with "no". how?

Application.DisplayAlerts = False does NOT work!
Don't ask me why... :(

Walt
 
Look in the help at workbooks.open command. It has an updatelinks argument.

workbooks.open filename:="C:\My Documents\Myfile.xls", updateLinks:=0

Regards,
Tom Ogilvy
 
Click on Tools, Options and select the Edit tab
Simply uncheck the "Ask to update automatic links" box

If you want to do it in code then it's
Application.AskToUpdateLinks = False
 
Which updates the links without asking - he said he didn't want the link
updated.

In Excel 2002, there are options under Edit=>Links for this I believe, but
not earlier verions.

Regards,
Tom Ogilvy
 
Back
Top