suppress popup message

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
 
T

Tom Ogilvy

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
 
L

libby

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
 
T

Tom Ogilvy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

embedding pw's to master sheet & auto update w/out pw's 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Suppress "Opening File" Alert 0
MS Query 7
Suppress warning message 2
Update Links 1
Can't delete sheets 8
Move some sheets to a new workbook, without macros, and withoutbreaking link btwn Pivot Tables and P 0

Top