Textboxes in Excel 2007 Beta 2 Macros
I think I have 2 problems with textboxes in Excel 2007.
This line of code used to work in old versions:
ActiveChart.Shapes.AddTextbox(msoTextOrientationHo rizontal, 415, 75.01
, 245, 17).Select
Selection.Characters.Text = "My Text Blah Blah"
But now, it does not work in Excel 2007 Beta 2. (Hangs up on the first
line.) However, if I change "ActiveChart" to "ActiveSheet", and then
click over to a non-chart sheet, it works fine.
Next problem. I try record macros so Excel will tell me how to do it,
but it seems it does not record the TextBox insert steps. Whether it
be in a chart or sheet.
Bottom line, I'd like to get some form of text labels on a bar chart.
Any solution is appreciated.
|