View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bigbri bigbri is offline
external usenet poster
 
Posts: 1
Default Multiple Users in Userform issue


Hi all,

I know I'm probably just forgetting something stupid, but here's m
issue:

I created a small userform to act as a Call Log. It worked fine, but w
had some Accumulation issues. So I set it up to have everyone's Userfor
to save to the same workbook on the Network drive. Everyone can pull u
the userform simultaneously with no issues, but only the first user ca
save data to the sheet.

I know the issue is probably a "Read-Only" problem, but I can't figur
out how to set it up where everyone's userform can write to the shee
at the same time (5 users). I had them pulling up the form from a loca
script, and tried also directly from the workbook on the network.

I'm good with VBA, but by no means great. Any help would b
appreciated.
-
Side Question: How hard would it be to save individual data on eac
person's local drive as well as to the main accumulative workbook?

--
bigbr
-----------------------------------------------------------------------
bigbri's Profile: http://www.excelforum.com/member.php...fo&userid=2221
View this thread: http://www.excelforum.com/showthread.php?threadid=53060