Thread: How do I make a macro automatically select Yes when a yes/no box appears?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Papou Papou is offline
external usenet poster
  
Posts: 67
Default How do I make a macro automatically select Yes when a yes/no box appears?
Try
Application.DisplayAlerts = False

and remember to set it back to True when you're finished

HTH
Cordially
Pascal


Reply With QuoteReply With Quote