sam314159
07-19-2010, 01:16 PM
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.
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.