Save everytime a cell is edited

[RSnap3232]

does anyone know a way to get excel to save every time a cell in column C is edited, I have a spreadsheet where multiple users can be working on at the same time and want to ensure they don't use the same reference number, already have it so it updates every ten minutes in the advance options under share workbook but looking for a more robust method

 

[EFANYoutube]

Hi RSnap
Please make sure the below code is pasted into the Sheet module
For example double click on Sheet1(Sheet1) in the project window

Private Sub Worksheet_Change(ByVal Target As Range)
            If Target.Column = 3 Then ThisWorkbook.Save

End Sub

 

[RSnap3232]

Hi RSnap
Please make sure the below code is pasted into the Sheet module
For example double click on Sheet1(Sheet1) in the project window

Private Sub Worksheet_Change(ByVal Target As Range)
            If Target.Column = 3 Then ThisWorkbook.Save

End Sub

thats worked like a charm thank you