Hi Bach,

Use the .Saved workbook property.

Application.ActiveWorkbook.Save
Application.ActiveWorkbook.Saved = True

Best regards

John

"bach" wrote in message
...

Hi,

I have spreadsheet to which users are adding data via UserForms. I
would like to save the data as the user is entering it and to remove
the 'Do you want to save changes' message box that appears when the
user closes down excel.

Any idears

Regards

Bach


--
bach
------------------------------------------------------------------------
bach's Profile:
http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=473685