Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Rerouting connectors

In Excel 2003, I have sheets where I draw rectangular boxes around a group of
3 cells, then using the draw tool, draw lines connecting (and snapping to
anchor points of) the boxes.

Then, with later operations, I select 5 cells that include the cell above
and below the 3 "boxed" cells, and drag the 5 cells to another location. The
box moves with the cells, but the line does not move with the cells.
However, there is a command in the draw tolls bar to "reroute connectors",
and when I select the line that did not move with the cells, then use the
"reroute connectors" command, the line automatically reconnects to the box at
it's new location. I can move multiple boxes, then select all the arrows
involved, and with one execution of "reroute connectors", all the relocated
boxes are connected to the boxes as they were originally connected.

In Excel 2007, there does not appear to be a similar command, and I am left
with manually reconnecting each box, a very tedious task. Is there a
"reroute connectors" command in 2007 that I overlooked, or can someone
suggest another option to reconnect boxes?

As a side note, in Excel 2003, I can select the object (the box around the
cells) and move it, and the arrows move with the box. However, the contents
of the cell do not move with the box, which is why I make my box smaller than
the nmumber of cells that I manipulate.
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
How do I delete Connectors? David Excel Worksheet Functions 1 October 6th 06 07:51 AM
How do I delete Connectors? David New Users to Excel 5 October 6th 06 06:49 AM
Autoshapes and connectors tonywig Excel Discussion (Misc queries) 1 April 19th 06 10:32 PM
Connectors FrankLP Charts and Charting in Excel 1 December 26th 05 03:25 PM
Comments and connectors Mark Excel Discussion (Misc queries) 1 April 27th 05 01:17 AM


All times are GMT +1. The time now is 01:14 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"