Is it possible to conduct a spell check on unlocked cells in a protected
document?
--
claudia

In both classic and Excel 2007, when a worksheet is protected, the Spell
took is greyed out (unusable)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Claudia" wrote in message
...
Is it possible to conduct a spell check on unlocked cells in a protected
document?
--
claudia

Hi,

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


--------------------------------------------------------------------------------



--
claudia


"Bernard Liengme" wrote:

In both classic and Excel 2007, when a worksheet is protected, the Spell
took is greyed out (unusable)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Claudia" wrote in message
...
Is it possible to conduct a spell check on unlocked cells in a protected
document?
--
claudia

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

On Tue, 12 May 2009 11:20:01 -0700, Claudia
wrote:

Is it possible to conduct a spell check on unlocked cells in a protected
document?

Gordon: what is the code for Canadian or UK spelling?
Thanks
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Tue, 12 May 2009 11:20:01 -0700, Claudia
wrote:

Is it possible to conduct a spell check on unlocked cells in a protected
document?