Macro Help - Suppress warning box
 

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

--
Message posted from http://www.ExcelForum.com

Macro Help - Suppress warning box
 

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

"ssmith " wrote in message
...
I'm writing a macro and deleting a worksheet. How can I suppress the
warning box for the user about deleting the worksheet?

Thanks,
Steve


---
Message posted from http://www.ExcelForum.com/

Macro Help - Suppress warning box
 

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 **

"ssmith " wrote in message
...
I'm writing a macro and deleting a worksheet. How can I suppress the
warning box for the user about deleting the worksheet?

Thanks,
Steve


---
Message posted from http://www.ExcelForum.com/

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