Re: Shape references to shapes on different pages

[Mark Nelson [MS]]

You must refer to shapes by their sheet name, not by their custom names.
Every shape can be expressed by using Sheet.N where N is the ID of the
shape. This name is shown in Format > Special or in the title of the
Shapesheet Window.

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

"Mark K" <ma...@enginuityeng.com> wrote in message
news:36CC77AB-5FAB-4B72...@microsoft.com...
> I am trying to get a shapesheet reference from a custom property on one
shape to be the guarded value on a different shapes custom property on a
different page.
>
> The visio help file section under HELP>DEVELOPER REFERENCE then tree
explored to:MICROSOFT OFFICE VISIO SHAPESHEET REFERENCE>>CONCEPTS>>ABOUT
CELL REFERENCES then reexplored to:CELL REFERENCE SYNTAX AND EXAMPLES
advises to use the formula "=Pages[Page-3]!Sheet.4!BeginX" to reference a
cell of a different shape on 'Another page in the document' which follows
the convention 'Pages[PageName]!SheetName!CellRef'.
>
> I have two pages in my drawing [Page-3] and [Page-2]. On Page-3 I have a
shape with the name of PP.MyShape. On Page-2 I have a shape with the name
PF.MySecondShape shapes. Both of these shapes have a custom property
defined as "Prop.MyCustomProp" that I want to link.
>
> So on Page-2, 'SHAPE' PF.MySecondShape 'SECTION' custom properties 'ROW'
Prop.MyCustomProp 'CELL' value I tried the following formula
=Guard(Pages[Page-3]!PP.MyShape!Prop.MyCustomProp) and keep getting an
error message.
>
> Then on Page-2, 'SHAPE' PF.MySecondShape 'SECTION' custom properties 'ROW'
Prop.MyCustomProp 'CELL' value I typed an equal sign "=" and mouse navigated
to the INSERT>>FUNCTION menu option. 'PAGES' is not even listed as a valid
funtion type.
>
> Does anyone know how to reference a cell from a shape on a different page
from a shapes custom properties in Visio 2003?
>
> Any assistance is greatly appreciated.
>
> Mark