View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Simon Lloyd[_358_] Simon Lloyd[_358_] is offline
external usenet poster
 
Posts: 1
Default Spell Check in Text Boxes


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