accept others changes in share workbook

[RSnap3232]

hello All,

I have a shared spreadsheet where it saves after the users edit certain columns (the first and last of the spreadsheet)

the idea is that when they enter the first it will save and of course if there is a conflict it means they do not have the latest version while the last column is to ensure they save their work.

My issue is I want to ensure when there is conflicting information that it always accepts the other user or the only option is to only accept the other users edit as it shows they are not working with the latest version.

Any help will be greatly appreciated.

 

[jasonb75]

Perhaps you could eliminate conflicts by saving when the first column is selected rather than when it is edited?

 

[RSnap3232]

Perhaps you could eliminate conflicts by saving when the first column is selected rather than when it is edited?

I am using the following VBA how would I change it to save when the cell is selected as that might be a good solution

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

 

[jasonb75]

You would need 2 procedures in the same module. This will save when column A is selected or column I is edited.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 9 Then ThisWorkbook.Save
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 Then ThisWorkbook.Save
End Sub

 

[RSnap3232]

You would need 2 procedures in the same module. This will save when column A is selected or column I is edited.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 9 Then ThisWorkbook.Save
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 Then ThisWorkbook.Save
End Sub

that is brilliant I think that is a way round what I needed thank you.