Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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...et.f unctions |
#2
|
|||
|
|||
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 wrote in message ... 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...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
Spell Check | Excel Discussion (Misc queries) | |||
Counting Unique Cells When Spread Sheet is Filtered | Excel Worksheet Functions | |||
move between unlocked cells on protected sheet | Excel Discussion (Misc queries) |