LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
C C is offline
external usenet poster
 
Posts: 61
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spell Checking with checking cell notes jfitzpat Excel Discussion (Misc queries) 0 August 8th 07 10:26 PM
spell checking options dvs_47 Excel Worksheet Functions 2 March 6th 06 09:16 PM
Spell Checking Text Boxes? Don Wiss Excel Programming 2 December 26th 04 11:32 PM
Spell checking text boxes Don Wiss Excel Programming 4 December 5th 03 10:52 AM


All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"