Macro Help - Suppress warning box

[ssmith]

I'm writing a macro and deleting a worksheet. How can I suppress th
warning box for the user about deleting the worksheet?

Thanks,
Stev

 

[Michael Malinsky]

Application.DisplayAlerts = False 'turn off warnings
Application.DisplayAlerts = True 'turn on warnings

HTH
--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

 

[Paul B]

Application.DisplayAlerts = False
'Your Code
Application.DisplayAlerts = True

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[ste mac]

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

.....After your sheet deletion
Application.Displayalerts = True

Hope that does it for you..

seeya ste