LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default Macro's and Graphical Objects

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.

"Sunday88310" wrote:

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"
Using 2007
Please rate respnces.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graphical button and Macro David T Excel Discussion (Misc queries) 2 February 21st 07 02:51 PM
Hide Macro's in Toolbar / Macro's list sparx Excel Discussion (Misc queries) 2 May 6th 06 08:53 PM
Graphical Representation cityinday Excel Discussion (Misc queries) 4 March 19th 06 04:44 AM
Creating a graphical formula from a set of data rmellison Charts and Charting in Excel 1 October 17th 05 11:35 AM
graphical problems Damsel in distress Charts and Charting in Excel 0 April 5th 05 02:47 PM


All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"