Multi-user dilemma.

[GCF]

I have a work macroo that is very simple. When a user enters a ten digi
number, it does a find in the range of G100:G65000. It has thre
responses : 1 not a ten digit number, 2 found (no action), 3 The te
digit number is added to the next G cell, and is available for the nex
find (re-run of the macro).

In an attempt to go multi-user it was apparent that the users where i
contention for the same cells at the same time.

Is there a method or code that would allow for one to take precedence
and the other to append to the applied changes, or am I looking at thi
all wrong?

Thank yo

 

[Harald Staff]

Hi

Multiuser environment and 65k + data records is what databases do very well.
You shouldn't use a spreadsheet program for this.

HTH. Best wishes Harald