Shapes slow down Macro in Excel 2007
 

(Excel 2007)
I am currently running a macro (VBA) that draw lines (similar to a line
chart) on a worksheet. The more lines that the Macro draws the slower the
process gets. In Excel 2003 the whole process took about 60 seconds and now
in 2007 it is takes up to 3 hours. I had the same issue with 2003 but I got
around it by grouping the lines together every so often (basically like
starting over with one object) However in 2007, that trick does not work.
Any ideas on how to flatten the objects out into one object and not be able
to ungroup it?

Shapes slow down Macro in Excel 2007
 

One way to speed up a VBA procedure that uses shapes is to avoid selecting
the shapes. This is especially true in Excel 2007. Also, turn off screen
updating while creating the shapes, so Excel doesn't feel the need to redraw
each shape a thousand times.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"David S." <David wrote in message
...
(Excel 2007)
I am currently running a macro (VBA) that draw lines (similar to a line
chart) on a worksheet. The more lines that the Macro draws the slower the
process gets. In Excel 2003 the whole process took about 60 seconds and
now
in 2007 it is takes up to 3 hours. I had the same issue with 2003 but I
got
around it by grouping the lines together every so often (basically like
starting over with one object) However in 2007, that trick does not work.
Any ideas on how to flatten the objects out into one object and not be
able
to ungroup it?

Shapes slow down Macro in Excel 2007
 

For the OP

See
http://www.rondebruin.nl/shape.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Jon Peltier" wrote in message ...
One way to speed up a VBA procedure that uses shapes is to avoid selecting
the shapes. This is especially true in Excel 2007. Also, turn off screen
updating while creating the shapes, so Excel doesn't feel the need to redraw
each shape a thousand times.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"David S." <David wrote in message
...
(Excel 2007)
I am currently running a macro (VBA) that draw lines (similar to a line
chart) on a worksheet. The more lines that the Macro draws the slower the
process gets. In Excel 2003 the whole process took about 60 seconds and
now
in 2007 it is takes up to 3 hours. I had the same issue with 2003 but I
got
around it by grouping the lines together every so often (basically like
starting over with one object) However in 2007, that trick does not work.
Any ideas on how to flatten the objects out into one object and not be
able
to ungroup it?