Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spell check and protection
I know that you're not able to use spell check in a protected sheet/workbook.
However, I need to create a sheet that allows users (non excel proficient) to check spelling and at the same time not being able to change any locked cells. Is there another way around this so that I can protect certain fields without turning off the spell check feature. Thanks -- Mici |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spell check and protection
Mici, you could assign this macro to a button on the sheet, it will
unprotect the sheet, spell check, and then protect the sheet back 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 "Mici" wrote in message ... I know that you're not able to use spell check in a protected sheet/workbook. However, I need to create a sheet that allows users (non excel proficient) to check spelling and at the same time not being able to change any locked cells. Is there another way around this so that I can protect certain fields without turning off the spell check feature. Thanks -- Mici |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Spell Check in Protected Worksheet & Shared Workbook | Excel Discussion (Misc queries) | |||
spell check for protected worksheet for Excel 97 | Excel Discussion (Misc queries) | |||
Protection of check boxes in excel 2002 | Excel Discussion (Misc queries) | |||
Spell Check w/ Protection | Excel Discussion (Misc queries) |