Hi Jim,

Not too encouraging ... don't want to revert to 2003 as I'm now used to the
many design changes in 2007, but this is first time I've had to run VBA in
2007 - and like I say, run speed is okay it is the development that is slow.

If I find a solution, I will come back here to post.

"Jim Cone" wrote:

For what it is worth...
MS is now bragging? http://blogs.msdn.com/excel/
that xl2010 (preview version) handles charts much faster then xl2007.
It will only require ~twice as much time as XL2003.
--
Jim Cone
Portland, Oregon USA