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
|