How to stop auto saving each time?

Hi friends,
The code in sheet module ‘change line and save’ is working fine but only a little problem is there when I enter any value in the range ‘c:z’ then the macro runs and save the entry in that particular row which I don’t want. I want to save the entry when I enter any value in column z’ only and not any other column.

The code is:

Please Login or Register  to view this content.

Any help will be appreciated.

Thanking you,

Move the lines for workbook save and msgbox to BEFORE End Select line.

Hi millz,
Thank you. The problem is solved.

Thank you and have a nice day.