View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default 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!