Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Auto-Layout Shapes in Excel

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Shapes in Excel is greyed out, what do I do? Kevin P. Excel Discussion (Misc queries) 4 October 3rd 07 07:24 PM
Naming Auto Shapes and Creating new Shapes AL2000 Excel Discussion (Misc queries) 3 September 10th 07 04:12 AM
Auto Shapes Launchnet Excel Discussion (Misc queries) 4 April 17th 06 05:41 AM
How can i get more 3D shapes for Auto shapes in excel? Ajey Excel Discussion (Misc queries) 0 March 3rd 05 09:53 AM
How can i get more 3D shapes for Auto shapes in excel? Ajey Excel Discussion (Misc queries) 0 March 3rd 05 09:53 AM


All times are GMT +1. The time now is 06:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"