avoid message that asks for confirm delete sheet
 

What statement can avoid the confirmation of deleting a worksheet during a
macro run?

thank you

avoid message that asks for confirm delete sheet
 

Craig,

Application.displayalerts=false

'your delete code

Application.displayalerts=true

Mike

"Craig" wrote:

What statement can avoid the confirmation of deleting a worksheet during a
macro run?

thank you