Spell check in a protected sheet

G

Guest

I built a form which includes numerous check boxes and text boxes. Due to
the sensitivity of the forumals, I have protected the sheet. Unfortunately,
my end users are unable to access the spell check function as a result.

Is there any way to protect the worksheet without disabling the spell check
feature in text boxes? Any help you guys can provide would be appreciated.

Thanks in advance.
 
G

Gord Dibben

You can use this macro to unprotect, run the spellcheck, then re-protect the
sheet.


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

I built a form which includes numerous check boxes and text boxes. Due to
the sensitivity of the forumals, I have protected the sheet. Unfortunately,
my end users are unable to access the spell check function as a result.

Is there any way to protect the worksheet without disabling the spell check
feature in text boxes? Any help you guys can provide would be appreciated.

Thanks in advance.
Click to expand...

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 on protected sheet 2
Spell Check with protected sheets 3
Enabling Spell Check in Protected Worksheet 2
Spell check when worksheet is protected 3
Spell check on a protected sheet 2
Spell Check in Protected Worksheets 3
Spell Check Unlocked Cells Only 9
Spell check and protection 1

Top