View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Text Box in Excel 2007 Chart

Hi Bill -

When working with the new shapes in Office 2007, the macro recorder doesn't
record anything, because Microsoft never hooked up the new shapes into the
recorder. Also some actions with charts are not recorded. This is an
unfortunate omission.

What text are you entering into the text box?

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


"Bill" wrote in message
ink.net...
Hello All,
A couple things I can't figure on Excel 2007 (the list seems to grow each
day). I tried to record a macro that adds a text box to an existing
chart. The text box gets added, but nothing is recorded. Any ideas?

Also, I can't seem to add text to the text box on the chart. It positions
the cursor in the text box, I enter the text, hit return and get a message
Reference is not valid. Any ideas?

Thanks,

Bill