Re: Spell Check in Protected Worksheets
- From: Gord Dibben <gorddibbATshawDOTca>
- Date: Fri, 09 Feb 2007 09:02:51 -0800
Using a macro is the only work around that I know of.
Sub Spell_Check()
Active***.Unprotect Password:="justme"
Cells.CheckSpelling SpellLang:=1033
Active***.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub
Unprotects the ***, does the spellcheck then reprotects the ***.
"justme" can be changed to your password.
Gord Dibben MS Excel MVP
On Fri, 9 Feb 2007 07:37:01 -0800, Jae <Jae@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I've read that the spell check function is not available in a protected
work***, but does anyone know of a work around?
Thanks in advance for you assistance.
.
- Prev by Date: Re: Rounding IF statement?
- Next by Date: Lookup and Indirect unexpected behavior
- Previous by thread: Re: Rounding IF statement?
- Next by thread: Re: Spell Check in Protected Worksheets
- Index(es):
