| 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) | |||
Hybrid Mode
