[Excel]Shared Workbook and Conflict Resolution
I have a shared workbook that acts as a database. The problem is that when two users entered data into the same cell, a conflict will occur and an error message box will be promted, asking the user whose data to discard. I was wondering if it is possible to execute these action, only when the error msg box pops up.
Code:
ThisWorkbook.ConflictResolution = xlOtherSessionChanges
Worksheets("Data").Cells(Counter, 1).Value = AAA
Worksheets("Data").Cells(Counter, 2).Value = BBB
Worksheets("Data").Cells(Counter, 3).Value = CCC
Worksheets("Data").Cells(Counter, 4).Value = DDD
Worksheets("Data").Cells(Counter, 5).Value = EEE
Worksheets("Data").Cells(Counter, 6).Value = FFF
Worksheets("Data").Cells(Counter, 7).Value = GGG
Work Worksheets("Validation").Cells(2, 1).Value = Counter + 1
The main idea to accept the other users changes and have the local data moved into the next row