shared workbook

[baha]

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.

 

[excelent]

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:

 

[baha]

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:

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