Macro's and Graphical Objects

[Guest]

2007 Excel
I was trying to use the recorder to build a graphical rectangle, fill it
with color, and so on. I have been unsuccessful in creating code. The VBE
code is only providing the location of the object but not the code associated
with creating the graphical Object. Any thoughts? Is the recording a
graphical object done differently in 2007 Excel?

 

[Guest]

You're going to find this rather useless behavior in a couple of areas
dealing with graphics objects - I found the same thing when trying to record
a macro while creating and modifying a chart. I didn't know until your post
that this goes over to less complex graphics also.

That problem was included in a paper I submitted to Microsoft about problems
I found with graphing in general a short while back. So as far as I know,
recording a macro for a graphic object isn't supposed to be done any
differently, but obviously it doesn't work properly.

Two work-arounds: if you have an earlier version of Excel handy, do the same
thing in it and copy the recorded code to the 2007 code module.

#2: I futzed along in my graphic effort by first creating a simple chart and
then recording macros as I then made changes to it from the keyboard and put
all of what I learned through these crippled efforts into a single code
section. The result worked - wasn't pretty, but worked.

Personally, if I were you, I'd post your question again, but the next time
choose New | Suggestion for Microsoft from the options if you're posting
directly into the MSFT discussion group forum (which I believe you are).
That would help make sure that someone from MSFT sees another complaint about
macro recording not working properly in Excel 2007.

 

[Jon Peltier]

The Macro Recorder doesn't see anything relating to the new shapes in Office
2007, which includes all of shapes and some of charts.

Jerry:

Could you email me a copy of that paper?

I'm not sure anyone from MS is really watching for suggestions in the news
groups, but I've already filed a bug through official channels about the
Macro Recorder.

- Jon

 

[Guest]

I'll send the whole thing to you. I sent it to our MVP Lead and he's
escalated it on up the chain.