Save workbook when user makes changes

I wrote a code that is suppose to save the workbook every time a change is made but so far I have been unsuccessful at getting it to work. The workbook contians 7 worksheets.
This is the code I wrote to try and accomplish this task

Please Login or Register  to view this content.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

Thanks.

Please Login or Register  to view this content.

Adding Code to the ThisWorkbook module in Excel 2003
1. Copy the code from the post
2. In the Excel window, right-click on the Excel logo in the upper-left corner and select View Code. This opens the Visual Basic Editor (VBE) and shows the object module for the workbook.
3. Paste the code in that window
4. Close the VBE to return to Excel

Please Login or Register  to view this content.

The save works great but now when i delete a row it will not allow me to select shift row option when deleting rows, allow it wil do is delete entire row.