Unprotect problem
 

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

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.)

Unprotect problem
 

Thanks Mike.

"Share workbook" is also greyed out. (I'm a novice with Excel!!).

John



"Mike H" wrote:

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.)