Save Workbook For Each Change Made In A Range

[Excel Fox]

Use this in the code module of the specific sheet where you make changes

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Application.Intersect(Target, Range("C:C")) Is Nothing Then
        Application.DisplayAlerts = False
        ThisWorkbook.Save
        Application.DisplayAlerts = True
    End If
    
End Sub