How can I protect a cell and keep the spell check working?

[ochoaex]

I'm working on an excel sheet on which I need to protect an specific
cell but everytime I protec them my spell check goes away.

Does anyone know how to do this??

Thanks

 

[Gord Dibben]

ocho

You can use this macro to unprotect, run the spellcheck, then re-protect the
sheet.


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


Gord Dibben Excel MVP

I'm working on an excel sheet on which I need to protect an specific
cell but everytime I protec them my spell check goes away.

Does anyone know how to do this??

Thanks

Gord Dibben MS Excel MVP