hi
guessing here but i suspect that you display alerts has somehow been turned
off.
press alt+F11. in the project window(far left), expand your project(file).
on the vbe tool bar, click insertmodule.
paste this code into the module.

sub fixit()
application.displayalerts = true
end sub

on the vbe toolbar, click run.

this may solve your problem. if not post back.

Regards
FSt1



"KCM" wrote:

After changing excel worksheet and closing the excel window, system does not
ask for save/Abort . it quit without saving and asking . How to rectify
the same