How to unlock workbook?

A

ADT57

When I select tools them protection all is greyed out but protect shared
workbook. I do not remember protecting any part of this work book. I want to
add a worksheet to this book. Under insert the worksheet is also grayed out.
Any help greatly appreciated.
 
L

Luke M

Shared workbooks have many features disabled. You'll need to first unshare
the workbook before protecting/unprotecting a sheet. It sounds like the
workbook was protected (preventing you from inserting a worksheet) and then
the workbook was shared (preventing you from unprotecting 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