Dear friends,

I have a problem with macro's I use in a network environment. If too
many people are linking to the same file at the same time, the workbook
is getting damaged, leaving only text, and one time I couldn't even open
it again with excel.
The workbooks aren't very big; they are used as registration lists for
trainings, with macro's that select the first empty cell if the lists
are very long, that gives an inputbox if someone forgets to fill in
some data and a macro that locks the cells with data in, so people
can't overwrite or delete registrations.
I disable 'tools' from the menubar so people can't unlock the sheets or
look for the password themselves.

If the book is opened readonly, I give a messagebox and make it close
immediately, without saving.

Usually the employees receive an e-mail with information about the
training and a link to the file(s). Registrations are between 20 and
700 per training,
depending on the target group. The files for little groups, with
registrations spread over a longer period of time, cause no problems.

What could be the reason the books are getting damaged if the target
group is very large?

Best regards,
Mike


--
Mikeyhend
------------------------------------------------------------------------
Mikeyhend's Profile: http://www.excelforum.com/member.php...o&userid=33400
View this thread: http://www.excelforum.com/showthread...hreadid=532219