suppress warnings

  • Thread starter Thread starter Claude
  • Start date Start date
C

Claude

Hi all

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

Thanks!
 
Hi
add the line
application.displayalerts = false
before the deletion code and the line
application.displayalerts = True
after the deletion
 
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
 
Back
Top