entries at the same time in shared workbook

[bahadirakcan]

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.

[royUK]

Sharing a workbook like that is not ideal. I think Access copes better than Excel in such situations.

[mudraker]

bahadirakcan


Please read forum rules & wrap your VBA code

A thread with the rules is available at the top of each forum or see links below

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950

[bahadirakcan]

Please Login or Register  to view this content.

I hope this time is correct post, I desperately need answer. if cannot be possible can you please let me know as well.

[royUK]

As I said in my earlier post, I am sure you will continue to get problems attempting to use Excel like this. There is no problem with your code, but if several users are attempting to run the code at the same time then you will have errors.