Thread: Macro Help - Suppress warning box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael Malinsky[_3_] Michael Malinsky[_3_] is offline
external usenet poster
  
Posts: 45
Default Macro Help - Suppress warning box
Application.DisplayAlerts = False 'turn off warnings
Application.DisplayAlerts = True 'turn on warnings

HTH
--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

"ssmith " wrote in message
...
I'm writing a macro and deleting a worksheet. How can I suppress the
warning box for the user about deleting the worksheet?

Thanks,
Steve


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote