suppress warnings

[Claude]

Hi all

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

Thanks!

 

[Frank Kabel]

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

 

[Robin Hammond]

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