Always accept my changes
 

Hello,

I have an excel workbook that multiple users update all day at the same time
in a Share Workbook inviroment. One copy of the database is the control and
has macros to save and perform other functions. What I need is when the same
cell is updated with different info, I need code to tell the control to
always "Accept mine".
Example;
Joe updates cell A1 with 99 Then saves
The control has auto updated cell A1 with 100.
When the macros on the control goto save, the save function is asking which
one of the data entries to save. I want the controls entry to always save no
matter what.

Can this be done? I have racked my brain trying to fingure this out. I could
not even record a similar sinario. Please help. Thank you in advance.

Always accept my changes
 

I've answered my own question. Thank you.

"SJW_OST" wrote:

Hello,

I have an excel workbook that multiple users update all day at the same time
in a Share Workbook inviroment. One copy of the database is the control and
has macros to save and perform other functions. What I need is when the same
cell is updated with different info, I need code to tell the control to
always "Accept mine".
Example;
Joe updates cell A1 with 99 Then saves
The control has auto updated cell A1 with 100.
When the macros on the control goto save, the save function is asking which
one of the data entries to save. I want the controls entry to always save no
matter what.

Can this be done? I have racked my brain trying to fingure this out. I could
not even record a similar sinario. Please help. Thank you in advance.