Posted to microsoft.public.excel.programming

AWSD

external usenet poster

Posts: 5

Display alerts error

Hi,

Within a Sub I have the following code fragment:

Application.ScreenUpdating = False
Application.DisplayAlerts = False
If SheetExists("Sheet3") Then Sheets("Sheet3").Delete
Application.DisplayAlerts = True

This works fine in Excel 2000 but a user using Excel 2002 has reported the
following error:

Method "display Alerts" of object '_Application' failed.

I cant see why the error is being raised. Is there a problem in 2002? Is
there a solution?

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
Display Alerts	MarkN	Excel Discussion (Misc queries)	0	June 8th 06 03:13 AM
Stopping Display Alerts	Mark	Excel Programming	1	February 8th 05 02:01 PM
Display Alerts	Earl[_4_]	Excel Programming	2	August 12th 04 08:18 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 10:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us