| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
spelling check on a protected spreadsheet
Thank you All, I've done it. I've used the Paul B approach:
Sub Spell_Check() ActiveSheet.Unprotect Password:="123" Cells.CheckSpelling _ CustomDictionary:="CUSTOM.DIC", _ IgnoreUppercase:=False, _ AlwaysSuggest:=True ActiveSheet.Protect Password:="123" End Sub "Alex" wrote: Hi, Can I allow a user to do a spelling check on a protected spreadsheet if some cells/columns are awailable for the data entries? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check Spelling With Sheet Protected | Excel Discussion (Misc queries) | |||
| how do you check and edit spelling on a protected sheet. | Excel Discussion (Misc queries) | |||
| ... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
| Spell Check an Unlocked Cell in a Protected Spreadsheet | Excel Worksheet Functions | |||
| Spell check a protected spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
