Thread: creating Shapes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Christof DB Christof DB is offline
external usenet poster
 
Posts: 14
Default 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