How to stop auto saving each time?

[mso3]

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,

[millz]

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

[mso3]

Hi millz,
Thank you. The problem is solved.

Thank you and have a nice day.