Deleting worksheets

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?
 
F

Frank Kabel

Hi

application.displayalerts=false
'deletion code
application.displayalerts=true
 
Top