Mike, see ProtectSharing and UnprotectSharing in VBA help files.



"Mike H" wrote in message
...
I have a spreadsheet that is shared by our work group. It has a macro that
reads cells on the DataEntry tab and writes to LogSheet tab. The LogSheet
tab is protected with a password, so the macro unprotects, writes, then
reprotects. This works just fine but when the workbook is shared the
macro
can not unprotect the sheet. Does anyone know why a macro can not
unprotect
a sheet in a shared workbook? I think this is Excel 2003 in Windows XP,
but
some of the stations might be Excel 97 on Win 2000, which might be the
root
of this problem.