"really straightforward"

Take that tongue out of your cheek before you choke on it!

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gklass" wrote in message
oups.com...
I'm disappointed in you guys, the solution is really straightforward.

1. don't uninstall 2003 when you install 2007
2. Create a textbox with some text in your 2007 file.
3. Create a dummy chart in 2003 Excel
4. Create a textbox in 2003 and paste the text there
5. Save the dummy 2003 file
6. Open the dummy file in 2007
7. Copy and paste the text from the dummy textbox.

Now, if I only could record a macro in 2007, I could automate this.







On May 28, 9:01 am, Andy Pope wrote:
I could only paste text in to a textbox if I copy the text from another
textbox.

If I copied a cell containing the new text pasting resulted in a new
series being added. Regardless of how I tried to select the textbox to
give it focus.

If I copied the text in a cell from the formula bar the Paste feature
was disabled when I selected the textbox.

All a bit hit and miss :(

Cheers
Andy

Jon Peltier wrote:
Five minutes with Excel 2007 show that there is no obvious way to paste
copied text into the embedded text box. Aren't you glad you upgraded?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

"Gklass" wrote in message
roups.com...

For some reason I am unable to paste text into a chart text box,
(with excel 2007).

Is there a trick to this?
Gary K.