Get rid of SaveAs prompts
On Aug 14, 2:51*pm, Bongard wrote:
It prompts me he
ActiveWorkbook.Close SaveChanges:=True '(It continues
to prompt me here on a couple workbooks)
I don't know if anyplace where I have date or time functions in the
workbooks.
Thanks,
Brian
Change the Save Changes to False.
If you want to save it as the same workbook and the same name use
ActiveWorkbook.Save
|