Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shared workbook
Hi everyone,
Let`s say I have one workbook which is shared by 40 different users on a network,this workbook has 3 objects such as,userform1,textbox1 and commandbutton1.Once commandbutton1 pressed the following code is activeted; Private Sub CommandButton1_Click() Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Select Selection.Value = TextBox1.Value End Sub it`s very basic right?But if user A,user B and user C open this workbook from different computer and press the commandbutton1 before they save the workbook there will be a message for ;three different users try to change the cell value,which entry excel needs to consider(sorry I don`t literary remember this message by word)is there a way to prevent that message and textbox1.value enter in the next below cell?If the question is not clear please let me know. Thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
shared workbook
Y i no bout this conflict problem, when several users change same cells and
in this case, u ned to paste value 1 or more rows down than ur code finds Im working with a shared workbook every day at my work (stock) Our problems are small compared with urs (1 conflict at a month or so) I was wondering - havent tryed my self - if u put code in ur code to save workbook just before u check for last not empty row. "baha" skrev: Hi everyone, Let`s say I have one workbook which is shared by 40 different users on a network,this workbook has 3 objects such as,userform1,textbox1 and commandbutton1.Once commandbutton1 pressed the following code is activeted; Private Sub CommandButton1_Click() Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Select Selection.Value = TextBox1.Value End Sub it`s very basic right?But if user A,user B and user C open this workbook from different computer and press the commandbutton1 before they save the workbook there will be a message for ;three different users try to change the cell value,which entry excel needs to consider(sorry I don`t literary remember this message by word)is there a way to prevent that message and textbox1.value enter in the next below cell?If the question is not clear please let me know. Thanks for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
shared workbook
On Dec 15, 10:20 pm, excelent
wrote: Y i no bout this conflict problem, when several users change same cells and in this case, u ned to paste value 1 or more rows down than ur code finds Im working with a shared workbook every day at my work (stock) Our problems are small compared with urs (1 conflict at a month or so) I was wondering - havent tryed my self - if u put code in ur code to save workbook just before u check for last not empty row. "baha" skrev: Hi everyone, Let`s say I have one workbook which is shared by 40 different users on a network,this workbook has 3 objects such as,userform1,textbox1 and commandbutton1.Once commandbutton1 pressed the following code is activeted; Private Sub CommandButton1_Click() Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Select Selection.Value = TextBox1.Value End Sub it`s very basic right?But if user A,user B and user C open this workbook from different computer and press the commandbutton1 before they save the workbook there will be a message for ;three different users try to change the cell value,which entry excel needs to consider(sorry I don`t literary remember this message by word)is there a way to prevent that message and textbox1.value enter in the next below cell?If the question is not clear please let me know. Thanks for your help. thanks to your reply,Yeah that was an example, original file a bit more complicated.adding save workbook is the only solution for now.but there should be something better than that i believe.what surprise is not many people answer this subject,however I was thinking that was a good question.Anyway do you know anywhere else i can get help for my question.It`s really killing me:) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared workbook | Excel Worksheet Functions | |||
Printing viewing a shared workbook on a shared drive | Excel Discussion (Misc queries) | |||
update pivot in shared shared workbook | Excel Discussion (Misc queries) | |||
Shared Workbook? | Excel Discussion (Misc queries) | |||
Shared Workbook | Excel Discussion (Misc queries) |