Spell Check w/ Protection
 

Does anyone know how you can enable spell checking for a protected worksheet?

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?

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?

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?