View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Umlas Bob Umlas is offline
external usenet poster
 
Posts: 301
Default DisplayAlerts not working?

Switch the order:
Application.DisplayAlerts = False
Worksheets(1).Delete

"Aaron" wrote in message
...
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