Link shapes on different pages

[jeffc]

Hello, first post -- long time lurker.

My Visio knowledge is fairly limited, and hence am challenged while trying to resolve this issue.  What I am trying to accomplish is using a formula in one shape, to extract data from a shape on a different page.  This is for Audio/Visual drawings where a cable is split between two pages; I use a custom callout on each page with a hyperlink connecting them.  I've tried using <=Pages[Prop.Remote_Page]!Prop.Remote_ID!User.Grid>.  Whether I use the shape data method or directly entering the information into the cell's formula, I get an error.  It's really frustrating me as to why I cannot get it to work.  Is there a better way to go about this?  I'm a stranger to VB as well, but will do what I must to make this happen.  Thanks in advance for an and all help!

[jeffc]

Ok, let me throw one more thing out there; since this is a shape linked to a master, should I be using the following formula?

Masters[Mastername]! Shapename!Cellreference

Will it traverse pages without any other coding?

[Jumpy]

I presume that the page and the shape you want to link are stored inside the propertys that are referenced in your formula?

=Pages[Prop.Remote_Page]!Prop.Remote_ID!User.Grid

That wont work, because if Prop.Remote_Page="Page-1" and  Prop.Remote_ID="Sheet.123" then what you have in the formula is sth. like:

=Pages["Page-1"]!"Sheet.123"!User.Grid

Your propertys will be interpreted as strings I guess. So you either don't use the propertys and place Page and Shape directly in formula:

=Pages[Page-1]!Sheet.123!User.Grid

or u create a new user defined cell with a formula like:

=DEPENDSON(Prop.Remote_Page)+SETF(GETREF(User.MyCell),"=Pages["&Prop.Remote_Page&"]!"&Prop.Remote_ID&"!User.Grid")

that pushes the correct formula to the cell User.MyCell whenever Prop.Remote_Page changes. Use similar formula for changes in Prop.Remote_ID or add a second Dependson to the one formula abobe, but I don't know if that will work.

[JamesB]

Any results Jeffc?

[Surrogate]

This thread can be helpful!