avoid message that asks for confirm delete sheet

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

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

thank you
 
Craig,

Application.displayalerts=false

'your delete code

Application.displayalerts=true

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro : confirm Delete 2
Removing confirmation POP from excel 4
Macro, Auto Return 1
Can warning messages be suppressed in Excel? 4
Confirm deletion 1
Delete Worksheets in same excel 4
Avoid Window Message while deleting a sheet 4
Delete worksheet without confirmation 1

Back
Top