Spell Check

B

Bernard Liengme

In both classic and Excel 2007, when a worksheet is protected, the Spell
took is greyed out (unusable)
best wishes
 
C

Claudia

Hi,

I just discovered you can create a macro that will temporarily disable the
protection and run spell check.
 
G

Gord Dibben

Note: tested on 2003 and 2007

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 with protected sheets 3
Spell Check on Excel document 2
Spell Check Unlocked Cells Only 9
How does a user spell check protected document in Excel? 6
Enabling Spell Check in Protected Worksheet 2
Spell Check in Protected Worksheet & Shared Workbook continued 1
spell check protected document 1
possible to run a spell check on a protected spreadsheet? 2

Top