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

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


--
ochoaex
------------------------------------------------------------------------
ochoaex's Profile: http://www.excelforum.com/member.php...o&userid=31150
View this thread: http://www.excelforum.com/showthread...hreadid=508238

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

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




On Fri, 3 Feb 2006 12:15:43 -0600, ochoaex
wrote:


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