Results 1 to 2 of 2
Thread: Multiple users, same user form
2001-01-24, 19:50 #1
- Join Date
- Jun 2002
- Durham, North Carolina, USA
- Thanked 1 Time in 1 Post
Multiple users, same user form
I'm using Word 97 to do some text inserts. Essentially my users fill in some items on a user form in vba. When they click Next the text is inserted into the document and they proceed to the next form. Unfortunately I've just learned (the hard way) that if two users are in the form at the same time, only one can click next and proceed. The other user clicks Next and the second form never shows up.
Due to other constraints, everyone must use the same copy, or I'd just put multiple copies in separate folders. A friend suggested an Auto_Open macro that makes someone wait until the first user is done, but I'm not sure how to do that.
Any help is greatly appreciated.
2001-01-25, 00:22 #2
- Join Date
- Dec 2000
- New York, NY
- Thanked 29 Times in 27 Posts
Re: Multiple users, same user form
The proper way to do this would be to set up a template. Then each user will always create a new separate document from the template. Is that feasible in your situation?Gary Frieder