"Peter T" <peter_t@discussions wrote in message
...
Hi Jon,

How to do a simple little thing like format the line weight

which in previous versions the macro recorder would give
sr.Border.Weight = xlThin

you'll have to rely on the Object Browser and IntelliSense.

Border (for Series) has curiously become a "hidden member" in 2007

Just means it's not the "official" way to do something, but it's not
completely deprecated. A lot of things we do in 97-2003 make use of hidden
leftovers from Excel 5.

Ah, with an educated guess looks like this is it
sr.Format.Line.Weight

Andy Pope has figured out much of the formatting OM. Check his web site, and
hunt for newsgroup responses he's authored.

The macro recorder is totally busted for shapes, and pretty much busted
when it comes to formatting chart elements

That's progress for you!

That's spending all of your time and resources on partial development of an
untenable UI, and not having enough left to make real improvements
elsewhere.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______