Macro can not unprotect a sheet in a shared workbook

M

Mike H

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.
 
D

Dave Peterson

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.
 
M

Mike H

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
 
G

Gord Dibben

Mike

You are confusing workbook protection with worksheet protection.

Not the same thing.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect / Unprotect Sheet in Share Workbook Excel 1
overriding the Workbook Unprotect-function 2
unprotect worksheet error 3
Need macro to copy active sheet to a new workbook 1
Running Macros in a Shared File 2
Protect / unprotect a form 1
Unprotect in a macro 4
Protecting sheet in a macro doesn't work 1

Top