Unprotect problem
in [Functions]
|
From: DJohnM on 11 Apr 2010 04:02 How do I unprotect a worksheet in Excel 2007 when "unprotect sheet" is greyed out? (I have matching problem with protecting.)
From: Mike H on 11 Apr 2010 04:11 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.)
From: DJohnM on 11 Apr 2010 04:42 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.)
|
Pages: 1 Prev: Alternative of Vlookup Next: Removing multiple duplicate events |