Deleting worksheets
 

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?

Deleting worksheets
 

Hi

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Oscar" schrieb im Newsbeitrag
...
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?