Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want a cell should 2 accept only =0 or <=30 or Y or N | New Users to Excel | |||
Accept or Reject a value | Excel Worksheet Functions | |||
Accept EULA ? | Excel Programming | |||
Track/Accept Changes | Excel Worksheet Functions | |||
Accept on condition only ! | Excel Programming |