"When i disabled the alert the deleted excel worksheet din got save its still there only and only the alert msg has got hidden..."

You didn't save before closing, what do you expect to happen? See also What shortcuts can I use for linking to other information?.