Macro Help - Suppress warning box
Hi Steve...
I'm writing a macro and deleting a worksheet. How can I suppress the
warning box for the user about deleting the worksheet?
This should do it..
....In front of your sheet deletion
Application.Displayalerts = False
delete your sheet<<<<<<<<
.....After your sheet deletion
Application.Displayalerts = True
Hope that does it for you..
seeya ste
|