"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.
|