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.

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.

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:)