Thread: Why is the option to unprotect a worksheet 'grayed out'
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Why is the option to unprotect a worksheet 'grayed out'
As a guess your workbook is shared. You can not unprotect a sheet on a shared
workbook. If you need to do that you will have to unshare the book first.
--
HTH...

Jim Thomlinson


"rook" wrote:

What can I do to rectify this situation.
Reply With QuoteReply With Quote