Can you perform spell check on a protected sheet in excel? If not is there a
macro or program that will do spell check while the sheet is protected?

Brent

You must unprotect the sheet, spellcheck then re-protect the sheet.

Sub Spell_Check()
ActiveSheet.Unprotect Password:="justme"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub

Note: was written using xl2003 so you may have to change the 1033 to accomodate
xl2000. Never having used xl2000 I'm not sure about that.


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 13:04:01 -0800, Brent
wrote:

Can you perform spell check on a protected sheet in excel? If not is there a
macro or program that will do spell check while the sheet is protected?

Gord Dibben MS Excel MVP