How do I turn off the Delete Confirm in Excel/VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook which contains only VBA which acts on another workbook and
produces up to 20 working worksheets which I cancel with Sheet(X).Delete, how
do I prevent up to 20 msgboxes asking me to confirm that I want to delete
 
Hi
application.displayalerts=false
'delete code
application.displayalerts=true

--
Regards
Frank Kabel
Frankfurt, Germany

Terry Lawson said:
I have a workbook which contains only VBA which acts on another workbook and
produces up to 20 working worksheets which I cancel with Sheet(X).Delete, how
do I prevent up to 20 msgboxes asking me to confirm that I want to
Click to expand...
delete
 
You must log in or register to reply here.

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

getting rid of the "confirm delete" dialogue box when deleting a s 5
I can only delete an entire row not a cell in excel 2013? 1
Summary sheet including only open projects. 1
Cannot Move, Copy, Insert, Rename, or Delete a Worksheet in Any Wo 6
'Cannot insert object' message when I try to put a button on a worksheet 7
how do I delete a "Workbook" from the Excel menu? 3
In Excel 2003 - how do you switch off the "Confirm Delete" functi. 1
How do I remove VBA projects in Excel 4

Back
Top