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.

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.