Check Spelling With Sheet Protected

G

Gord Dibben

Using a macro is the only work around that I know of.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spell Check Protected WORKBOOK 1
Spell Check issue 2
Excluding a paragraph tag from spelling check 0
Spell Check 4
Spell Check with protected sheets 3
MS Project - error message when checking "Critical tasks" 1
Word OLE to check spelling in text box 1
Changing language from UK to US English 0

Top