If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Spell Check
Is it possible to conduct a spell check on unlocked cells in a protected
document? -- claudia |
#2
|
|||
|
|||
Spell Check
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 news Is it possible to conduct a spell check on unlocked cells in a protected document? -- claudia |
#3
|
|||
|
|||
Spell Check
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 news Is it possible to conduct a spell check on unlocked cells in a protected document? -- claudia |
#4
|
|||
|
|||
Spell Check
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? |
#5
|
|||
|
|||
Spell Check
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? |
Thread Tools | |
Display Modes | |
|
|