Spell Check in Protected Work Book

[ChrisK]

Hi,
How can I leave spell check available for a range of cells while protecting
the rest of the sheet?

 

[trip_to_tokyo]

Hi Chris.

I have just conducted a simple test whereby I restricted access to 3 cells
but left the rest of the Worksheet available for edit.

In the above circumstances the Spell Checker is greyed out so it appears
that you are not able to do what you are looking for.

If my comments have helped please hit Yes.

Thanks.

 

[Gord Dibben]

Using a macro is the only work around that I know of.

Sub Spell_Check()
ActiveSheet.Unprotect Password:="justme"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub

Unprotects the sheet, does the spellcheck then reprotects the sheet.

"justme" can be changed to your password.


Gord Dibben MS Excel MVP