Shape references to shapes on different pages

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 HELPDEVELOPER REFERENCE then tree explored to:MICROSOFT OFFICE VISIO SHAPESHEET REFERENCECONCEPTSABOUT 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 INSERTFUNCTION 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

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" wrote in message
...
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 HELPDEVELOPER REFERENCE then tree
explored to:MICROSOFT OFFICE VISIO SHAPESHEET REFERENCECONCEPTSABOUT
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 INSERTFUNCTION 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