shared document: protection issues
 

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

shared document: protection issues
 

Not sure where you are looking, but under limitations for shared workbooks it
says:

Protect or unprotect worksheets or the workbook. Existing protection remains
in effect.

That is from a list of things you can't do.

--
Regards,
Tom Ogilvy


"Arne" wrote:

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