Spelling Check on Protected Sheets

  • Thread starter Thread starter CMA
  • Start date Start date
C

CMA

I want to protect a worksheet and distribute to other
people. But they may want to do a spelling check on the
data entered. Is that possible.

Thanks
 
They will not be able to enter incorrectly spelt (any) words on a protected
sheet . Simply spell check it for them prior to distribution

Mike
 
what about if some of the cells are not protected and
users are able to enter data( text - reason for the
results) into those cells...can they spell check those
cells.

Thanks
 
In a word, no. At least not for XL97 and 2000. Once a sheet is protected
Excel disallows some functionality for the entire sheet even if some or all
cells are not locked. Spell check is among them. XL2002 has expanded the
options available for protected sheets, but I don't know if spelling is one
of them.

The workaround would be to write your own macro that reprotects the sheet
with userinterfaceonly, then calls the checkspelling method.

Something like:
ActiveSheet.Protect userinterfaceonly:=True
Cells.CheckSpelling
 
Back
Top