Unprotect shared worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stefi - 19 Jan 2006 13:58 GMT

Hi All,

I created a protected worksheet in a shared workbook in order to allow the
users accessing only certain cells, but in macros I should like to change
some locked cells. Unfortunately XL2000 doesn't allow UnProtect method in a
shared workbook.
What can I do to fulfil both requirements (sharing and unprotecting)
simultaneously?

Thanks,
Stefi

Reply to this Message

Dave Peterson - 19 Jan 2006 15:08 GMT

You can't.

You have to make a choice.

If you drop the sharing, you can protect the worksheet with
userinterfaceonly:=true--so your macro can change things that the user can't.

But this setting doesn't stick after you close the workbook and reopen it. You
have to change the protection when the workbook is reopened. And sharing the
workbook kills that, too.

> Hi All,
>
[quoted text clipped - 7 lines]
> Thanks,
> Stefi

Signature

Dave Peterson

Reply to this Message

Stefi - 20 Jan 2006 10:01 GMT

Thanks Dave, I'm not happy, but the question is cleared!
Regards,
Stefi

„Dave Peterson” ezt írta:

> You can't.
>
[quoted text clipped - 18 lines]
> > Thanks,
> > Stefi

Reply to this Message