ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to unlock workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/262742-how-unlock-workbook.html)

ADT57

How to unlock workbook?
 
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.

Luke M[_4_]

How to unlock workbook?
 
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).

--
Best Regards,

Luke M
"ADT57" wrote in message
...
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.





All times are GMT +1. The time now is 11:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com