spell check on protected sheet

  • Thread starter spell check on protected sheet
  • Start date
S

spell check on protected sheet

I have a worksheet where the questions are protected but the responses areas
are not. Is there anyway to enable the spell check on a protected sheet?
 
M

Mike H

Hi,

Try this in a general module.

Sub SpellCheck()
ActiveSheet.Unprotect Password:="MyPass"
Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", AlwaysSuggest:=True
ActiveSheet.Protect Password:="MyPass"
End Sub

Mike
 
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

Enabling Spell Check in Protected Worksheet 2
Spell Check on Excel document 2
Spell check when worksheet is protected 3
Spell Check with protected sheets 3
Spell Check 5
Spell check in a protected sheet 1
Spell check on a protected sheet 2
Spell Check Protect Reprotect with same settings 1

Top