I am building a workbook for several users to enter data.
There are a number of fields for each record, and the users may not know there is a conflicting save point (created by another user) until after they've spent a decent amount of time in the workbook.
Is it possible to have a VBA code that continuously runs in the background- so that when one party double clicks to enter contents in a cell - no other parties can select that cell?
This would essentially eliminate the need for the "conflicts" box that pops up after - because it would make sure there are no conflicts.
I know several of you out there are smart enough to figure this out, but I have not been able to solve this.
Thank you for the advice!!
There are a number of fields for each record, and the users may not know there is a conflicting save point (created by another user) until after they've spent a decent amount of time in the workbook.
Is it possible to have a VBA code that continuously runs in the background- so that when one party double clicks to enter contents in a cell - no other parties can select that cell?
This would essentially eliminate the need for the "conflicts" box that pops up after - because it would make sure there are no conflicts.
I know several of you out there are smart enough to figure this out, but I have not been able to solve this.
Thank you for the advice!!
