Save without prompts

I save off a backup copy of the sheet using the Auto_Close sub. However, I
always get asked to save it since a copy exists already.

ActiveWorkbook.SaveAs "h:\VBA Work\Transit Master_0.3\Transit Master_0.3.xls"

always returns the message to save. Can I save this off and avoid the
prompts like I can when I close a file

Precede the save code with

Application.DisplayAlerts = False

and set it back to true afterwards.

--

HTH

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


"Jeff" <[email protected]> wrote in message
news:[email protected]...
> I save off a backup copy of the sheet using the Auto_Close sub. However, I
> always get asked to save it since a copy exists already.
>
> ActiveWorkbook.SaveAs "h:\VBA Work\Transit Master_0.3\Transit
Master_0.3.xls"
>
> always returns the message to save. Can I save this off and avoid the
> prompts like I can when I close a file