"Update: I am unable to delete particular worksheets when i delete few sheets manualy its asking me a prompt like "There exists some data on your sheet do you want to permanently delete this sheet" will that be a possibility for not deleting my particular sheets???"

Firstly, one question mark will do. Secondly you disable alerts then close the workbook, what do you expect to happen?