C
Claudia
Is it possible to conduct a spell check on unlocked cells in a protected
document?
document?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
In both classic and Excel 2007, when a worksheet is protected, the Spell
took is greyed out (unusable)
best wishes
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.
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
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
B
Bernard Liengme
Gordon: what is the code for Canadian or UK spelling?
Thanks
Thanks
B
Bernard Liengme
Gordon: what is the code for Canadian or UK spelling?
Thanks
Thanks