PDA

View Full Version : Solved: Switching the Worksheet Deletion Warning Off?



londresw
09-30-2008, 02:23 PM
Hi,

Is there a way, when deleting a worksheet, of ensuring that the user is not promted each time with:

"Data may exist in the sheet(s) selected for delection. To permanently delete the data, press Delete."

which then gives the user a chance to 'delete' (rather repetitive) or 'cancel' - disasterous for my code!

Thanks as ever,

Scott

:help

Bob Phillips
09-30-2008, 02:31 PM
Application.DisplayAlerts = FALSE 'reset to TRUE at end

londresw
09-30-2008, 02:45 PM
thank you for the super-fast response, worked perfectly.