MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Delete sheet


Posted by Ben on April 05, 2001 1:49 PM

How do I write a macro that deletes a worksheet without warning/asking the user.

Thanks
Ben


Posted by Barrie Davidson on April 05, 2001 1:52 PM

At the beginning of your macro insert the following:

Application.DisplayAlerts=False

This turns off the warnings. Don't forget to turn it back on at the end of your macro.
Application.DisplayAlerts=True

Posted by Ben on April 05, 2001 2:06 PM

Thanks Again

Thanks Again
Ben