Bob was pointing out that if there are any changes to be saved, Excel will
give the user a message box for confirmation.
If there are no changes since the last save, then is nothing save, so no
need for confirmation from the user.

If you feel you need to duplicate Excel's capability, put you msgbox in
Workbook_BeforeClose event.
But users may be confused if you are asking them to Save/Not save when they
know they have made no changes since the last save.

NickHK

"vumian" wrote in
message ...

hi Bob Phillips,

yeah, if file has not bean changed, nothing happened

if anything changed, private msgbox popup

it mean the same property of Microsoft Excel.

thanks in advance


--
vumian
------------------------------------------------------------------------
vumian's Profile:
http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=568642