Lee Ann -
This surprised the heck out of me, but in Excel 2007 when I recorded
the process of spell-checking one textbox and then played a bit more it
looks like this simple sub will do what you need:
Public Sub SpellCheckTextboxes()
Cells.CheckSpelling SpellLang:=1033
End Sub
It seems to start at Cell A1 and then works its way down and to the
right, looking for textboxes and spell-checking the text in them.
Please let me know if this works for you...
--
jamescox
------------------------------------------------------------------------
jamescox's Profile:
http://www.thecodecage.com/forumz/member.php?userid=449
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=120599