View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default 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.