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 |
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 |
All times are GMT +1. The time now is 03:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com