Saving Forms

[kirkm]

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

 

[Guest]

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

 

[kirkm]

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

Many thanks, Kirk