Application.Displayalerts wont get me past this!

Posted to microsoft.public.excel.programming

andycharger[_27_] andycharger[_27_] is offline

external usenet poster

Posts: 1

Application.Displayalerts wont get me past this!

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date format from excel to CVS file wont. Change in CVS wont stay.	Fish''s Mermaid	Excel Worksheet Functions	1	October 14th 06 12:28 AM
Excel Red X is grayed out & wont close application how do I fix	chuckhn60	Excel Discussion (Misc queries)	1	June 16th 06 08:30 PM
goal seek wont calculate an accurate value past 3 decimal places	Joe Browning	Excel Discussion (Misc queries)	1	April 13th 05 07:29 AM
Application::DisplayAlerts not working	Howard Dierking	Excel Programming	2	February 11th 04 12:04 PM
application.displayalerts	Erin[_5_]	Excel Programming	1	December 4th 03 03:49 PM

All times are GMT +1. The time now is 11:33 AM.

Menu

About Us