Application.DisplayAlerts = False
.... code
Application.DisplayAlerts = True

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SP" <none wrote in message ...
Hi

ActiveWorkbook.SaveAs newfilename

If newfilename already exists at the saving location, a prompt will pop up
to confirm overwrite. Can I say Yes through the codes instead of manually
clicking on the Yes button ?

Thanks
Steve