I have a spreadsheet that needs a user input.


It says
"This workbook contains links to other data sources

If you update this, Excel attempts to retrieve the latest data.
If you dont update, excel uses the existing data"

There are 3 buttons, Update, Dont Update and Cancel.

I want it to just press the Update option as its highlighted and carr
on but application.Displayalerts = False does not get it past it.

Any ideas

--
Message posted from http://www.ExcelForum.com