One other thought - check the properties for the text boxes 9i.e locked
etc), also where did you get the textboxes from? from the activex tools?jamescox;443990 Wrote:
Lee Ann -
Sorry, but I can't reproduce your problem in Excel 2007 with either my
original sub or Simon Lloyd's - they both work fine.
As a check, start with a blank workbook, type some misspelled text into
a cell, then throw a few shapes (a textbox and a shape to which you add
misspelled text), add a module and put either or both subs in (don't use
the same name for both, of course) and see if they work.
If they do, there may be some 'residual protection' on the shapes in
your original workbook that's keeping the code from being able to
spell-check them.
Let us know what you find out!
--
Simon Lloyd
Regards,
Simon Lloyd
'Microsoft Office Help' (
http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?userid=1
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=120599