Posted to microsoft.public.excel.programming

external usenet poster

Posts: 2

Display Alerts

How can I respond to a Display Alert using Visual Basic
for Excel? I've tried to use
Applicaiton.DisplayAlerts=False to disabler the alerts,
but the program locks up and closes. Looks like the
easiest way out is to respond to the alert by having my
macro respond 'yes' or 'no'. Can any one tell me how to
write the VB code line to do so? Earl

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
Alerts....	gustin	Excel Discussion (Misc queries)	4	January 3rd 10 11:43 PM
Display Alerts	MarkN	Excel Discussion (Misc queries)	0	June 8th 06 03:13 AM
Excel via intranet Display Alerts problem	Sarah[_4_]	Excel Programming	0	July 6th 04 04:35 PM
Display Alerts	Valerie[_2_]	Excel Programming	1	September 8th 03 09:43 PM
Code to not display delete sheet alerts	John[_46_]	Excel Programming	2	August 25th 03 01:44 PM

All times are GMT +1. The time now is 03:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us