Spell Check on Excel document

  • Thread starter Thread starter Michele
  • Start date Start date
M

Michele

I have an Excel 2007 document that I have protected and am being asked if
it's possible to enable Spell Check on the protected document.
 
Document or worksheet is protected?

If you mean worksheet you will need VBA to unprotect, spellcheck then
re-protect.

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

Unprotects the sheet, does the spellcheck then reprotects the sheet.

"justme" can be changed to your password.


Gord Dibben MS Excel MVP
 
Hi,

I assume some cells are unlocked on the protected sheet or there would be
nothing enetered that could be spelled incorrectly.

You need a macro. Put a buttion on your sheet and assign the code below.
Change the password to your password

Sub Button2_Click()
With ActiveSheet
.Unprotect ("mypass")
.CheckSpelling
.Protect ("mypass")
End With
End Sub
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top