Allow unprotected cells to spell check after sheet is protected

[Guest]

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/com...dg=microsoft.public.excel.worksheet.functions

 

[Ron de Bruin]

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