Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spell Check in Protected Work Book
Hi,
How can I leave spell check available for a range of cells while protecting the rest of the sheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spell Check in Protected Work Book
Hi Chris.
I have just conducted a simple test whereby I restricted access to 3 cells but left the rest of the Worksheet available for edit. In the above circumstances the Spell Checker is greyed out so it appears that you are not able to do what you are looking for. If my comments have helped please hit Yes. Thanks. "ChrisK" wrote: Hi, How can I leave spell check available for a range of cells while protecting the rest of the sheet? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spell Check in Protected Work Book
Using a macro is the only work around that I know of.
Sub Spell_Check() ActiveSheet.Unprotect Password:="justme" Cells.CheckSpelling SpellLang:=1033 ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _ Contents:=True, Scenarios:=True End Sub Unprotects the sheet, does the spellcheck then reprotects the sheet. "justme" can be changed to your password. Gord Dibben MS Excel MVP On Fri, 15 Jan 2010 17:17:01 -0800, ChrisK wrote: Hi, How can I leave spell check available for a range of cells while protecting the rest of the sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using Spell check on protected sheet | Excel Worksheet Functions | |||
Spell check in a protected sheet | Excel Discussion (Misc queries) | |||
Spell Check Work Book | Excel Discussion (Misc queries) | |||
Spell check a protected spreadsheet | Excel Discussion (Misc queries) | |||
Why doesn't spell check work on a protected worksheet? | Excel Worksheet Functions |