how to popup msgbox once exit ?

[vumian]

hi everyone,

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

Click 'Yes' or 'No'

thanks in advance.

[Bob Phillips]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[vumian]

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]

hi everyone,

no one can help me

please help me in this case.

thanks in advance

[NickHK]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[vumian]

hi man,

if users have no change,i let them straight exit