MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Deleting sheets, without ok prompt

Posted by Mustard on January 31, 2002 11:48 AM

I have made a macro which deletes a sheet- Sheets("Student data printout").Delete
I am wondering if anyone knows what i can do to stop the prompt which asks 'are you sure you wish to delete' (or equivalent) from coming up, or how to program a macro to select yes.....

Posted by mkk on January 31, 2002 12:03 PM

Application.DisplayAlerts = false