settings required

K

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
 
F

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
 
S

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
 
Top