Thread: Display Alert
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default Display Alert

Sub GoForIt ()
Application.DisplayAlerts = False
'Run some code
Application.DisplayAlerts = True
End Sub

MIke F
"FrankJIN" wrote in message
...
The excel will set Application.DisplayAlerts to "true" as default as the
macro running was done.

Is it possible to set this default value as "false"?

Thanks.