Page reference in ShapeSheet

I

Iwan van Ee

I have a reference in shapesheet of a shape to a User defined cell in another
pagesheet:
Pages[Rack-4]!ThePage!User.Pagename

That works fine and gives me the name of that page. Now when I change the
name of the page Rack-4 to Rck4 (shorter name). This formula remains
unchanged. But the result of the formula gives me Rck4.
When I try to add a new formula into another Shapes Shapesheet which has a
reference to that page also I normally would insert the formula with the new
pages name:
Pages[Rck4]!ThePage!User.Pagename

This doe not work. I have to use the old name of the page in the formula
which I normally don't know.

How do I have to enter a working formula? I know the function GetRef(),
should I use that one?

This 'error' is also for shapes that have a reference to a cell in another
shape on another page.

I use Visio 2003.
 
M

Mark Nelson [MS]

This relates to local and universal names for objects. A page has two
names - a local name and a universal name. When the page is initially
created these names are the same. The Shapesheet always works with
universal names, so you use [Rack-4] to reference it properly. The page tab
always displays local names. When you rename a page, you are changing the
local name only. The universal name is unchanged, which is why your
formulas still work.

The only way to set a universal name is through code, but that would be the
way to update it to match the universal name.

--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top