Save without prompts

G

Guest

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
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top