Thread: msg boxes
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default msg boxes

Sub Macro1()
*
* Recorded by doug
*
Application.DisplayAlerts = False

' current code

Application.DisplayAlerts = True
End Sub

might be what you are after.

--
Regards,
Tom Ogilvy

"doug" wrote in message
...
i have a macro that i recorded and when i run it, it pops
up msg boxes to confirm what i want to do....is there a
way to make these msg box selections behind the scenes in
the macro
thanks
doug