Deleting worksheets

  • Thread starter Thread starter Oscar
  • Start date Start date
O

Oscar

I have a for each loop which moves through each worksheet
and deletes those that fail a test.

However, each time it deletes I get a message saying that
the worksheet is to be deleted and an OK and a Cancel
button.

What do i have to add to my code to not get this message?
 
Hi

application.displayalerts=false
'deletion code
application.displayalerts=true
 
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

Error deleting worksheet (Excel 2003) 2
Can't delete sheets 8
Deleting veryHidden worksheets 5
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
write vba to a worksheet via a macro 3
Delete Hidden Sheets 3
Conditional Row Delete on Steriods 1
Code to copy worksheet 5

Back
Top