View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
StargateFanFromWork[_4_] StargateFanFromWork[_4_] is offline
external usenet poster
 
Posts: 51
Default "Save" macro problem, still prompted to save when closing workbook (?)

I got this code from the archives to save the workbook: ThisWorkbook.Save

When I'd recorded saving the workbook earlier, the code was very similar,
ActiveWorkbook.Save.

The difficulty is that after using either macro, yes, I do see the saving
message at the bottom of the workbook that alerts me to the saving process
but when I immediately go to close the workbook, I'm still prompted to save
it. Yet when I click on FILE SAVE, I close the workbook and the prompt
doesn't come up.

Is there better code to use rather than either workbook.save that will
really save the file?

TIA.