settings required
 

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

settings required
 

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

settings required
 

Hi,

Do you edit the sheet before closing if yes then it should prompt you to
save. Other wise try and do Crtl+S after editing.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"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