Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spell Check with protected sheets
I read the past posts on doing sprell check on a protected sheet but still
having issues. I need a macro that will do spell check on only unlocked cells (this includes text boexes) Any help? Thank you -- Karissa |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spell Check with protected sheets
Hi,
Try this Sub Spell_Check() ActiveSheet.Unprotect Password:="Tech09" Cells.CheckSpelling SpellLang:=1033 ActiveSheet.Protect Password:="Tech09", DrawingObjects:=True, _ Contents:=True, Scenarios:=True End Sub Unprotects the sheet, does the spellcheck then reprotects the sheet. "Tech09" can be changed to your password. -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Karissa" wrote: I read the past posts on doing sprell check on a protected sheet but still having issues. I need a macro that will do spell check on only unlocked cells (this includes text boexes) Any help? Thank you -- Karissa |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spell Check with protected sheets
Thanks for that here are my other issues that maybe you can help.
I need it to check ONLY unprotected cells as well as editing text boxes. When I run this macro it skips over text boxes. Thank you for any help -- Karissa "Suleman Peerzade" wrote: Hi, Try this Sub Spell_Check() ActiveSheet.Unprotect Password:="Tech09" Cells.CheckSpelling SpellLang:=1033 ActiveSheet.Protect Password:="Tech09", DrawingObjects:=True, _ Contents:=True, Scenarios:=True End Sub Unprotects the sheet, does the spellcheck then reprotects the sheet. "Tech09" can be changed to your password. -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Karissa" wrote: I read the past posts on doing sprell check on a protected sheet but still having issues. I need a macro that will do spell check on only unlocked cells (this includes text boexes) Any help? Thank you -- Karissa |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spell Check with protected sheets
If I use the following VBA it will not spellcheck my text boxes. Any
suggestions? If I do spell check the regular way with no protection on it spell checks the text boxes no problem. If I record those same actions and try to replay it - it will not check the text boxes. Sub Spell_Check() ActiveSheet.Unprotect Password:="justme" Cells.CheckSpelling SpellLang:=1033 ActiveSheet.Protect Password:="justme", DrawingObjects:=True, Contents:=True, Scenarios:=True End Sub -- Karissa "Karissa" wrote: Thanks for that here are my other issues that maybe you can help. I need it to check ONLY unprotected cells as well as editing text boxes. When I run this macro it skips over text boxes. Thank you for any help -- Karissa "Suleman Peerzade" wrote: Hi, Try this Sub Spell_Check() ActiveSheet.Unprotect Password:="Tech09" Cells.CheckSpelling SpellLang:=1033 ActiveSheet.Protect Password:="Tech09", DrawingObjects:=True, _ Contents:=True, Scenarios:=True End Sub Unprotects the sheet, does the spellcheck then reprotects the sheet. "Tech09" can be changed to your password. -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Karissa" wrote: I read the past posts on doing sprell check on a protected sheet but still having issues. I need a macro that will do spell check on only unlocked cells (this includes text boexes) Any help? Thank you -- Karissa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spell check when worksheet is protected | Excel Discussion (Misc queries) | |||
can I use spell check on a protected spredsheet | Excel Discussion (Misc queries) | |||
Spell check protected sheet | Excel Discussion (Misc queries) | |||
Spell check in a protected sheet | Excel Discussion (Misc queries) | |||
spell check protected document | Excel Discussion (Misc queries) |