message2
the input box comes up. i want to in vb code (outside
excel) run the macro and say yes to the input box ?
so no pop ups


message1
I have basic code running a macro in a excel sheet.
i want to set the input box automatically to yes.
Then finish running the macro...

Other idea is to:
there is a default of yes so I could do a msgbox type
of
thing with excel.Application.DisplayAlerts = False but
for a inputboxs.

Mike