Spell Check cells in Protected Worksheet?

G

Guest

Is it possible to run the spelling checker on a worksheet when the worksheet
is protected?
It doesn't appear that it is possible through Excel's "normal" options.
A customer has created a protected Excel form with certain cells unlocked
for data. If the person misspells data in these cells, the spelling checker
is not available.
Any way around this?
Any suggestions would be appreciated!
Thanks.
Jugglertwo
 
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

Is it possible to run the spelling checker on a worksheet when the worksheet
is protected?
It doesn't appear that it is possible through Excel's "normal" options.
A customer has created a protected Excel form with certain cells unlocked
for data. If the person misspells data in these cells, the spelling checker
is not available.
Any way around this?
Any suggestions would be appreciated!
Thanks.
Jugglertwo
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 5
Enabling Spell Check in Protected Worksheet 2
How does a user spell check protected document in Excel? 6
corrupted formula in protected worksheet 21
Spelling checker problem on a specific worksheet only 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Inserting a comment box in a protected worksheet 2
Protecting certain cells only & Spell check 3

Top