msg boxes
 

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

msg boxes
 

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)

"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

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