Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spell check
How do I set Excel so others can Spell check data in a protected sheet?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spell check
Tonks, use a macro to unprotect the sheet, spell check, and then protect the
sheet, like this, assign to a button on the sheet Sub Spell_Check() 'spell check a protected sheet Const Password = "123" '**Change password here** ActiveSheet.Unprotect Password:=Password Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True ActiveSheet.Protect Password:=Password End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Tonks" wrote in message ... How do I set Excel so others can Spell check data in a protected sheet? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spell check
word wrap may be a problem with the other one
Sub Spell_Check() 'spell check a protected sheet Const Password = "123" '**Change password here** ActiveSheet.Unprotect Password:=Password Cells.CheckSpelling CustomDictionary:= _ "CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True ActiveSheet.Protect Password:=Password End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Paul B" wrote in message ... Tonks, use a macro to unprotect the sheet, spell check, and then protect the sheet, like this, assign to a button on the sheet Sub Spell_Check() 'spell check a protected sheet Const Password = "123" '**Change password here** ActiveSheet.Unprotect Password:=Password Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True ActiveSheet.Protect Password:=Password End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Tonks" wrote in message ... How do I set Excel so others can Spell check data in a protected sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
Spell check and protection | Excel Discussion (Misc queries) | |||
Spell Check in Protected Worksheet & Shared Workbook | Excel Discussion (Misc queries) | |||
Auto spell check as in word | Excel Discussion (Misc queries) | |||
spell check protected document | Excel Discussion (Misc queries) |