msg boxes

[doug]

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

 

[Bob Phillips]

Do you mean put the answers in the code? Surely that would mean that you
know in advance what will be chosen, so just take that logic route.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

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

' current code

Application.DisplayAlerts = True
End Sub

might be what you are after.