View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Unprotect sheet/workbook

Hi,


Maybe it's a shared workbook and if it is?

Unshare the workbook, unprotect, make your changes, protect and the re-share.

Mike

"Steve" wrote:

I protected the worksheets and the workbook. Now I need to unprotect them for
some changes, but on the review tab, unprotect sheet and unprotect workbook
is grayed out. I did not use any password. How can I unprotect this
workbook/worksheets.

Thanks,

Steve