Saving Forms
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
|