Spelling Check on Protected Sheets

[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

 

[Mike Hughes]

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

 

[CMA]

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

 

[Tim Zych]

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

 

[Dave Peterson]

Take a look at this thread.

http://groups.google.com/groups?threadm=O4wpEVUdCHA.1656@tkmsftngp11

Dick Kusleika provided a macro that would unprotect the sheet, do the spellcheck
(against only the unlocked cells), then reprotect.