View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Unprotect problem

Hi,

Is the workbook 'shared', if so you'll have to unshare it before you can
protect/unprotect any sheets.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"DJohnM" wrote:

How do I unprotect a worksheet in Excel 2007 when "unprotect sheet" is greyed
out? (I have matching problem with protecting.)