A change to any cell in column I will trigger workbook.save

Hello i have a worksheet that i need to apply code to so that when the user changes any cell in column I or 9 the workbook would automatically save. so far i have this code but it doesnt work for me

Please Login or Register  to view this content.

any help is good

hensucker,


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Select the worksheet in which your code is to run
3. Right click on the sheet tab and choose View Code, to open the Visual Basic Editor
4. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
5. Press the keys ALT + Q to exit the Editor, and return to Excel

Please Login or Register  to view this content.

Then in the worksheet column I, make some changes/additions/deletions.

Thank You for the code works like a treat.

hensucker,

You are very welcome. Glad I could help.

Thanks for the feedback.

Come back anytime.