Shapes slow down Macro in Excel 2007

D

David S.

(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?
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Shapes in 2007 3
Macro slow (worked well until I upgraded my machine) 3
manipulating drawing objects in MS Office 2007 2
Zoom problem with shapes in Excel 2007 2
Shapes in 2010 1
Problems starting Word from Excel VBA 3
Excel 2007 is slow when you hide columns on .xls 3
alternate rowshading using conditional format excel 2007/2010 6

Top