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:

Private Sub Worksheet_Change(ByVal Target As Range)

With Target
      Select Case .Column

Case 26
                        Range("C" & .Row + 1).Select
                     
       End Select
       End With
       
       ActiveWorkbook.Save
       MsgBox "The entry is saved!", 64
       
End Sub

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.