It's always great if posters mention their Excel version. If you have Excel
2002 or 2003 the Edit, Links dialog has a "Startup Prompt" button where you
can tailor the prompt, including not having one (which is heaven in my
book).

--
Jim Rech
Excel MVP
"andycharger " wrote in message
...
|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 carry
| on but application.Displayalerts = False does not get it past it.
|
| Any ideas?
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|