Hello,

I am writing a little VBA program that should enable two users to fill in
data on a shared wkb. I am a fan of shielding the actual data on the
worksheet(s) from direct access by the users by an interface (userforms).
Thus, the worksheets are protected, and the data are submitted through a
form. The data are tranferred to the sheets after being checked and
processed. To be able to write the data, the sheets must be temporarily
unprotected, but to my horror and surprise that does not work in a shared
workbook. The 'Unprotect' method fails, it tells me. Yet the help file
(windows 2000 professional and corresponding Excel verion) tells me nothing
about that. Can this problem be avoided/solved? Thanks in advance,

Arne