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.

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.

Changing sheet protection is one of the many features that is not available in
shared workbooks.

Check excel's (not VBA's) help for a larger list.

Mike H wrote:

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.

--

Dave Peterson

The knowlegebase article 263564 says if a shared workbook is protected but
does not have a password, the workbook remains shared after you remove the
protection.
That's how mine should work but I didn't get a chance to check it out today,
maybe Monday.

Mike


"Dave Peterson" wrote:

Changing sheet protection is one of the many features that is not available in
shared workbooks.

Check excel's (not VBA's) help for a larger list.

Dave Peterson


Mike H wrote:

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.

Mike

You are confusing workbook protection with worksheet protection.

Not the same thing.


Gord Dibben MS Excel MVP

On Fri, 18 Dec 2009 17:09:01 -0800, Mike H
wrote:

The knowlegebase article 263564 says if a shared workbook is protected but
does not have a password, the workbook remains shared after you remove the
protection.
That's how mine should work but I didn't get a chance to check it out today,
maybe Monday.

Mike


"Dave Peterson" wrote:

Changing sheet protection is one of the many features that is not available in
shared workbooks.

Check excel's (not VBA's) help for a larger list.

Dave Peterson


Mike H wrote:

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.