suppress warnings
 

Hi all

How can I suppress warnings like "selected sheet will be
permanently deleted" while a macro deleting sheets is
being run?

Thanks!

suppress warnings
 

Hi
add the line
application.displayalerts = false
before the deletion code and the line
application.displayalerts = True
after the deletion

-----Original Message-----
Hi all

How can I suppress warnings like "selected sheet will be
permanently deleted" while a macro deleting sheets is
being run?

Thanks!
.

suppress warnings
 

Claude,

application.displayalerts = false
your code
application.displayalerts = true

You might want to have a look at Google's group search feature which has
answers like this archived. This one pops up a lot.

Robin Hammond
www.enhanceddatasystems.com

"Claude" wrote in message
...
Hi all

How can I suppress warnings like "selected sheet will be
permanently deleted" while a macro deleting sheets is
being run?

Thanks!