hi everyone,

i wanna create private msgbox once exit
it mean : Do you want to save ...

Click 'Yes' or 'No'

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

If the file has been changed, doesn't that happen automatically?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vumian" wrote in
message ...

hi everyone,

i wanna create private msgbox once exit
it mean : Do you want to save ...

Click 'Yes' or 'No'

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

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

hi everyone,

no one can help me

please help me in this case.

thanks in advanc

--
vumia
-----------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...fo&userid=3649
View this thread: http://www.excelforum.com/showthread.php?threadid=56864

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

hi man,

if users have no change,i let them straight exit


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