View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SJW_OST[_2_] SJW_OST[_2_] is offline
external usenet poster
 
Posts: 39
Default 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.