View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
ste mac ste mac is offline
external usenet poster
 
Posts: 117
Default Macro Help - Suppress warning box

Hi Steve...
I'm writing a macro and deleting a worksheet. How can I suppress the
warning box for the user about deleting the worksheet?


This should do it..

....In front of your sheet deletion
Application.Displayalerts = False

delete your sheet<<<<<<<<


.....After your sheet deletion
Application.Displayalerts = True

Hope that does it for you..

seeya ste