Macros and Graphic recording???

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?

--
William<"M"> 2007


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...5-2603ceb47eec&dg=microsoft.public.excel.misc
 
There is no recording of macros relating to shapes in Excel 2007. The new
office art drawing engine took a great deal of work to build, and there was
apparently not enough time left before rushing off to manufacturing to get
the VBA information into the macro recorder. This also affects much of the
new charting engine, which relies on the new office art shapes.



I suspect that it will be reinstated either in the next version of Excel, if
not in a service pack for Excel 2007.


- Jon
 
Back
Top