Posted to microsoft.public.excel.programming

external usenet poster

Posts: 287

DisplayAlerts not working?

Hi,
Can someone possibly explain what's happening with this:
Worksheets(1).Delete
Application.DisplayAlerts = False

This appears to work on occasions - as in, I have the same piece of code
several places, and some of the sheets are deleted without confirmation, some
need confirmation. Anyone any ideas why this is happening?

Thanks

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
DisplayAlerts = false not working	Mark Stephens	Excel Programming	4	June 13th 05 06:05 AM
Displayalerts not working	Hari[_3_]	Excel Programming	11	January 14th 05 06:13 PM
Application.Displayalerts = value (is not working for me)	[email protected]	Excel Programming	3	December 18th 04 02:00 AM
application.displayalerts is not working	will lam	Excel Programming	2	April 30th 04 08:21 PM
Application::DisplayAlerts not working	Howard Dierking	Excel Programming	2	February 11th 04 12:04 PM

All times are GMT +1. The time now is 06:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us