Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating Shapes
I have a macro which first removes all shapes of a
workbnook and then creates a set of shapes (10 to 300) The removal is very fast: I create a shaperange with the ones to delete and then delete them all at once. Creating the new ones however takes quite a while. I suspect it would be faster if I first build all the shapes in memory, as a datastructure, and then add them all at once to the worksheet. Problem1: how to create a shape which is not part yet of a worksheet Problem2: if that is not possible, then what suggestion is there to speed it up? Thanks in advance Christof |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
alternative coordinates for creating shapes | Excel Discussion (Misc queries) | |||
When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
Creating shapes from given criteria | Excel Worksheet Functions |