Creating a custom property to reference a sheet number

[dmyers]

Hello,

I am trying to set up a Custom Property that will display the sheet number of a different shape.  I have looked through the shape sheet and could not find a field for the Sheet Number.  Is there any way to have a custom property refer to a sheet?

Thanks

[Jumpy]

The ShapeSheet-Function ID() will give you the shapes ID. Put it in a User. cell, for example.

Say you have to shapes Sheet.123 and Sheet.456 for example:
Shape1 (=Sheet.123), make a User cell named User.ID and in the Value colum you set: =ID()
Shape2 (=Sheet.456), make a User cell named User.Others_ID and in the Value colum you set: =Sheet.123!User.ID

But I don't know where the sense is in that, because to reference the first Sheet you already have to know the ID?

[dmyers]

Jumpy,

Thanks, that is exactly what I needed.  The reason I needed this was that when I added a new shape from the stencil I couldn't get the sheet number to update automatically, I would have to find the sheet number of the reference shape (both shapes are grouped together) and then input it manually.

Thanks