Unprotect shared worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thanks Dave, I'm not happy, but the question is cleared!
Regards,
Stefi


„Dave Peterson†ezt írta:
 

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

Running Macros in a Shared File 2
Protecting worksheet. 1
Macro can not unprotect a sheet in a shared workbook 4
Sharing workbook removes cell protection 1
Excel Protection 2
Programatically filter a protected shared workbook 4
Unprotect Workbook with Function 3
Copying in sheet with protection with the use of a macro 5

Back
Top