Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spell Checking a text box.
Greetings;
I wish to spell check a text box on one of my sheets. The worksheet that the text box is found on must be protected. I have the following code but it doesn't seem to work. It runs through the macro, but it doesn't detect any spelling errors when there is errors. Sub spell_check() ' ' spell_check Macro ' ActiveSheet.Unprotect ActiveSheet.Shapes("Text 2").Select Selection.CheckSpelling ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True End Sub Any help with this would be greatly appreciated. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spell Checking a text box.
c
This may help http://www.dicks-blog.com/archives/2...eck-a-textbox/ Make sure you read the comments. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com c wrote: Greetings; I wish to spell check a text box on one of my sheets. The worksheet that the text box is found on must be protected. I have the following code but it doesn't seem to work. It runs through the macro, but it doesn't detect any spelling errors when there is errors. Sub spell_check() ' ' spell_check Macro ' ActiveSheet.Unprotect ActiveSheet.Shapes("Text 2").Select Selection.CheckSpelling ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True End Sub Any help with this would be greatly appreciated. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spell Checking a text box.
Dick,
Thank you for your input. It isn't exctly what I was hoping for since the users of this program have very limited computing skills (may cause more problems), but I think I should be able to use one of the two methods suggested and make it work. I appreciate your time, Thanks again, C "Dick Kusleika" wrote: c This may help http://www.dicks-blog.com/archives/2...eck-a-textbox/ Make sure you read the comments. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com c wrote: Greetings; I wish to spell check a text box on one of my sheets. The worksheet that the text box is found on must be protected. I have the following code but it doesn't seem to work. It runs through the macro, but it doesn't detect any spelling errors when there is errors. Sub spell_check() ' ' spell_check Macro ' ActiveSheet.Unprotect ActiveSheet.Shapes("Text 2").Select Selection.CheckSpelling ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True End Sub Any help with this would be greatly appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
spell checking options | Excel Worksheet Functions | |||
Spell Checking Text Boxes? | Excel Programming | |||
Spell checking text boxes | Excel Programming |