Names of Shapesheets

[dave]

Recent changed the name of a sheet to Box 1. Now I can't edit any formula
to reference to newly named sheet. Every time I try to refernece Box 1 I
get and error in formula message. What have i done wrong this time?

 

[junethesecond]

Box 1 = Visio Rectangle ?
name of sheet = name of Visio shape ?
What name did you give?
Because certain names are rejected as is reserved by the system for the
name of Visio pages and shapes.

 

[dave]

Hi Junethesecond;

Ive renamed sheet5 of a multiple sheet shape (say that three times fast) to
"Window". The formulas in the shape cells referencd Sheet5! So i figured
on changing them to my new naming convention. I'm unable to do that. An
example of editing was GUARD(Sheet.5!Width-Prop.Dim_a) to
GUARD(Window!Width-Prop.Dim_a) It fails was "error in formula"

 

[junethesecond]

Do you mean grouped shape? If so. In Visio 2003.
It seems that reference to parent from child or from child to parent must
be made not by name but NameID, a NameID has a form like "sheet.11" not
"Window".
NameID can be known with NameID property in VBA macro, for example.
If "Window" is a parent,
Debug.Print ActivePage.Shapes("Window").NameID,
if child,
Set shpParent= ActivePage.shapes("Parent Nmae")
Debug.print shpParent.shapes("Window").NameID

 

[dave]

Hi junethesecond,
thanks for the reply. Still it seems strange to me and I tell you why.
When I use the name.id it worked fine for referncing the "window" sheet.
Then I changed some other cells and it mixed the use of name.id and "named"
sheet. example: I Entered in Width -
GUARD(Sheet.5!Width-Sheet.8!Width-Sheet.9!Width) and it returned
GUARD(Sheet.5!Width-Coupler.Right.Jamb!Width-Coupler.Left.Jamb!Width)
sheet.5 is named "Window" What up with that!
Dave


ame it work fine for that formula. I

 

[junethesecond]

Magic done by Visio. Not limited to it. If you change the name of sheet.8
or sheet.9, formula will be changed automatically. Beautiful magic done by
Visio.