How to unlock workbook?

  • Thread starter Thread starter ADT57
  • Start date Start date
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.
 
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

Similar Threads

How to change format protection default to unlocked? 2
Unlocking a Workbook 2
Unprotecting worksheets 2
Sharing workbooks limitations - Merged Cells 12
Protected workbooks blocking transfer of data 3
Locked Several Worksheets, allow format cells/select unlocked cell 2
Unable to Unlock Workbook 1
Inserting sheets into Excel workbook 6

Back
Top