Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel macro in 2007 runs extremely slow | Excel Discussion (Misc queries) | |||
Slow excel because of shapes? | Excel Programming | |||
Excel 2007 VBA-XLL macro speed slow | Excel Discussion (Misc queries) | |||
Macro run Very Slow in Excel 2007 | Excel Programming | |||
Formatting shapes with excel 2007 | Excel Discussion (Misc queries) |