Can you spell check protected but unlocked cells in excel2000?

[MarkB]

I have a lot of forms made using excel 2000. The sheets are protected but
cells that can be filled in are not locked. I have just noticed that the
spell check is disabled whilst the sheet is locked. Has anyone come across
this? and is there a fix/workaround?

Thanks

 

[Gord Dibben]

You must unprotect the sheet, 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

Note: was written using xl2003 so you may have to change the 1033 to accomodate
xl2000. Never having used xl2000 I'm am not sure about that.


Gord Dibben MS Excel MVP