Hi
one way: put the following in the workbook_beforeclose event:

activeworkbook.saved = true


--
Regards
Frank Kabel
Frankfurt, Germany


Nick wrote:
Hi,

I wuould like to know if any method can disable "save when change"
function in excel using vba. Since I do not want the pop-up when
closing the excel.

Thanks.

Nick