add this into your workbook:


Code
-------------------
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Su
-------------------



cheers,
gopp

--
Gopp
-----------------------------------------------------------------------
Goppi's Profile: http://www.excelforum.com/member.php...fo&userid=1582
View this thread: http://www.excelforum.com/showthread.php?threadid=27314