Excel 2007 Macro Recorded

[sam314159]

We recently upgraded to Excel 2007 and I was very surprised to find out that chart formatting is no longer recorded by the macro recorder and I have to actually learn to do this via code now.

This is kind of complicated for us non-developers who only dabble with VBA to get some repetitive tasks done.

1. Has anyone heard of any Microsoft plans to add that functionality back to the recorder in the future, I read somewhere that it just didn't make it due to lack of time.

2. Can anyone think of any alternatives besides learning to do it via code or using the recorder in a 2003 version of Excel and then copying and pasting the code?

3. Can anyone think of a good beginner guide to formatting charts via code? I tried googling for this but all I found were bits and pieces. I was hoping for some kind of 101 guide for someone who hasn't done a whole lot of chart formatting by hand.

Thanks in advance guys.

[Bob Phillips]

It's back in in 2010.

You could always record it in 2003 and then just copy it.

[sam314159]

I was hoping there was a way to update or patch 2007 to get that functionality back, guess not.

I am looking into getting 2010 now. Do you think there will be any compatibilty issues if I use 2010 to write the VBA code when everyone who will be using the files has 2007?

[Bob Phillips]

No, the changes for 2010 are minimal, mainly extra objects for the slicer, sparklines, and the re-introduction of the macro recorder.