Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Settiing up spellcheck in a protected Excel document
I am creating a form. I have locked certain cells, while others are
unlocked. The unlocked cells will be used to fill out the form. I would like the user to be able to use spellcheck. I have tried to use the 'Allow Users to Edit Ranges' under Protection by including all unlocked cells, but spellcheck is still locked out for the entire document as soon as I put in the password. Is there a way to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Settiing up spellcheck in a protected Excel document
teejay
You can use this macro to unprotect, run the spellcheck, then re-protect the sheet. 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 On Thu, 27 Apr 2006 08:24:01 -0700, teejay wrote: I am creating a form. I have locked certain cells, while others are unlocked. The unlocked cells will be used to fill out the form. I would like the user to be able to use spellcheck. I have tried to use the 'Allow Users to Edit Ranges' under Protection by including all unlocked cells, but spellcheck is still locked out for the entire document as soon as I put in the password. Is there a way to do this? Gord Dibben MS Excel MVP |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Settiing up spellcheck in a protected Excel document
Gord
Sorry I didnt reply right away. The macro worked fine after I changed the security. I am surprised that spellcheck is not made available when you protect the sheet. Thanks so much for your help. teejay "Gord Dibben" wrote: teejay You can use this macro to unprotect, run the spellcheck, then re-protect the sheet. 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 On Thu, 27 Apr 2006 08:24:01 -0700, teejay wrote: I am creating a form. I have locked certain cells, while others are unlocked. The unlocked cells will be used to fill out the form. I would like the user to be able to use spellcheck. I have tried to use the 'Allow Users to Edit Ranges' under Protection by including all unlocked cells, but spellcheck is still locked out for the entire document as soon as I put in the password. Is there a way to do this? Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I open an existing excel 2003 document | Excel Discussion (Misc queries) | |||
Difficult for me, probably basic to you | Excel Worksheet Functions | |||
How do I reduce the file size of an Excel document? | Excel Discussion (Misc queries) | |||
existing excel file when clicked opens blank excel document | Excel Discussion (Misc queries) | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |