how to unlock a workbook

M

Mellissa

I have a shared workbook. It is not password protected, but is locked. How
do I unlock it?
 
D

Dave Peterson

Do you mean that a worksheet is protected or that the workbook is protected (via
tools|protection)?

If yes, then look in Excel's help for "Features that are unavailable in shared
workbooks", you'll see a big old list.

One of them is that you can can't change the protection of a worksheet/workbook
in a shared workbook.

You'll have to unshare the workbook.
 

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

Top