Auto-Layout Shapes in Excel

G

Guest

I'm using Excel 2002 VBA to create a set of Shapes and Connectors in an Excel
worksheet.

I can hard-code a top and left position for each new Shape, but this doesn't
give me the flexibility I need. Does anyone know of a way of getting Excel
to automatically arrange the shapes on the sheet like the Shapes -> Lay Out
Shapes menu option in Visio?

I know there is a Reroute Connectors property for the connectors, but I
can't find anything to move the Shapes themselves.

Thanks in advance,

Tristan
 

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
Changing the test of checkboxes (shapes) programmatically? 3
Powerpoint VBA Issues - Looping through Shapes 0
searching for shapes 8
Change Shapes (countries in map) based on conditions 1
Zoom problem with shapes in Excel 2007 2
Shapes Fill 2
Shapes in 2010 1

Top