Spell check
How do I set Excel so others can Spell check data in a protected sheet?
|
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? |
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? |
All times are GMT +1. The time now is 03:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com