settings required

[KCM]

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

 

[FSt1]

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 insert>module.
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

 

[Suleman Peerzade]

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