Requires VBA to unprotect the sheet, do the spellcheck then reprotect the
sheet.
Similar to.......
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 Wed, 29 Dec 2004 12:33:05 -0800, "Peter"
wrote:
Thank You. Excellent suggestion that I think will do the job. Have a Happy
New Year.
"Frank Kabel" wrote:
Hi
you can't. You may record a macro which first unprotects the sheet, executes
spell checking and protects the sheet again
--
Regards
Frank Kabel
Frankfurt, Germany
Peter wrote:
Does anyone know how you can enable spell checking for a protected
worksheet?
|