Hi,
I'm having the same problem, but coding in VBA, and have done evething
stated here to get text to center in the textframe of the shape. And, it
works until I make the shape too small at which time the character's top are
the only part visisble as the character disappers as the shape gets smaller.
On another computer, at home, with Excell 2007 I don't get this problem, so I
know it's not the size of the shape causing the character to disapper out the
bottom (on one occasion it disappears out the top as it gets too small). My
work computer has excell 2003 and seems to cause this problem. Any help
would be appreciated.