Allow unprotected cells to spell check after sheet is protected

At times I unprotect certain areas of an Excel sheet. However, after I
protect the sheet I am not able to perform spell checks. On many occasions I
create forms/questionnaires, and protect the sheet so as the original format
will not be contaminated. If an area is unprotected within a protected
sheet, I should be able to spell check within the unprotected area.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

Gord posted this

Requires VBA to unprotect the sheet, do the spellcheck then reprotect the
sheet.

Similar to.......

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

Gord Dibben Excel MVP

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Numberonekraut (Hans)" <Numberonekraut (Hans)@discussions.microsoft.com> wrote in message
news:3EF78E3A-6415-406C-8DB9-2918AC980932@microsoft.com...
> At times I unprotect certain areas of an Excel sheet. However, after I
> protect the sheet I am not able to perform spell checks. On many occasions I
> create forms/questionnaires, and protect the sheet so as the original format
> will not be contaminated. If an area is unprotected within a protected
> sheet, I should be able to spell check within the unprotected area.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions