Could some explain how, through code, you "Save" the sheet when you
close a Form, so you don't get the message, "Are you sure
you want to save changes..." when you close the workbook ?

Many thanks - Kirk

In the code that you use to close the form place this line:
ActiveWorkbook.Save

Note that this save (as it implies) the "Active" workbook, if you want to
save the workbook that the macro is written in, use ThisWorkbook.Save
--
Charles Chickering

"A good example is twice the value of good advice."


"kirkm" wrote:


Could some explain how, through code, you "Save" the sheet when you
close a Form, so you don't get the message, "Are you sure
you want to save changes..." when you close the workbook ?

Many thanks - Kirk

On Thu, 22 Feb 2007 18:23:10 -0800, Charles Chickering
wrote:

In the code that you use to close the form place this line:
ActiveWorkbook.Save

Many thanks, Kirk