using spell check on a protected sheet

  • Thread starter Thread starter Lauren
  • Start date Start date
L

Lauren

I have protected a worksheet and left certain ranges
unlocked. One of the unlocked ranges contains text
explanations that will be periodically updated by various
users. I have discovered that even though these cells are
unlocked, spell check is unavailable. I have changed the
sheet protection to allow cell formatting, but this did
not solve the problem. The people typing into these cells
want to use spell check and I cannot figure out how to
make it available without leaving the whole sheet
unprotected
 
See reply in Misc group

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Lauren,
Same problem; I've tried every variant of sheet and
workbook protection. My searches at microsoft.com KB/sppt
yield no solution (nor does this newsgroup...yet).
--Scott
 
Back
Top