How can I activate spell check in a protected sheet

's Computer Specifications

's Computer Specifications

You can't.
You can't without unprotecting the sheet.
You can write a macro that will unprotect the sheet, do the spell check,
protect the sheet.

If users are going to run the macro you may want to prevent them from
breaking out of the macro.

John

"CKBW" <(E-Mail Removed)> wrote in message
news:375AB6B8-EE97-4B58-AB3F-(E-Mail Removed)...
>

's Computer Specifications

Any suggestions on how

"jaf" wrote:

> You can't.
> You can't without unprotecting the sheet.
> You can write a macro that will unprotect the sheet, do the spell check,
> protect the sheet.
>
> If users are going to run the macro you may want to prevent them from
> breaking out of the macro.
>
> John
>
>
>
> "CKBW" <(E-Mail Removed)> wrote in message
> news:375AB6B8-EE97-4B58-AB3F-(E-Mail Removed)...
> >
>
>

's Computer Specifications

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 Thu, 3 Jul 2008 15:05:01 -0700, CKBW <(E-Mail Removed)> wrote:

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Spell check protected sheet	=?Utf-8?B?U3V6YW5uZQ==?=	Microsoft Excel Misc	0	30th May 2007 05:52 PM
Protected sheet spell check	Liz	Microsoft Excel Misc	0	11th May 2006 05:05 PM
How I activate spell check in a protected word form?	=?Utf-8?B?RWR3YXJkIEE=?=	Microsoft Word Document Management	1	19th Jan 2005 07:52 PM
Is there a way to spell check a protected sheet?	matt	Microsoft Excel Misc	1	4th Oct 2003 01:53 AM
How to spell check a protected sheet?	Bill Rubin	Microsoft Excel Discussion	0	22nd Jul 2003 11:47 PM