View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon[_2_] Simon[_2_] is offline
external usenet poster
 
Posts: 89
Default 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