Page refrence

Hello all, does anyone know, how to make a refrence to a shape in
another page?

I have two shapes, "shapeA" and "shapeB" and both have been named liked
that. So now I want both to have always same text, and inserting
=SHAPETEXT(shapeA!TheText) formula to shapeB, I can do that.

But this doesn't work, if they are in different pages. How can I do
that?

Thanks!

--
al

Hi, al.

Here is an excelent document.
"About Cell References"
http://msdn.microsoft.com/en-us/library/ms195648.aspx

In my test shape name caused error, so I used shape ID.
SHAPETEXT(Pages[Page-2]!Sheet.1!TheText)

--
JuneTheSecond

Now, visual calculation is more visual.
http://www.geocities.jp/visualcalcul...ish/index.html

=?Utf-8?B?SnVuZVRoZVNlY29uZA==?= wrote in
microsoft.public.visio.general:

Here is an excelent document.
"About Cell References"
http://msdn.microsoft.com/en-us/library/ms195648.aspx

In my test shape name caused error, so I used shape ID.
SHAPETEXT(Pages[Page-2]!Sheet.1!TheText)

Ok, thanks for this! I will try that tomorrow at the office.

What I'm trying to do, is to create "master" elements for wireframes.

I'm very frustrated having eg. navigation element with 15-20 items in
15-50 (or 50..) pages. And when client asks to update navigation or
wants more pages, I have to update all those 50 pages. Same goes with
having annotations in several pages. As being moderately newbie with
Visio, I believe there is an easier way to do this, but this shapetext-
thingy has been very useful for me.

Thanks again.

--
al

Hello Al,

Have you come across background pages? You can place a shape on a
background page and then assign the page to any number of foreground pages.
That way you could have a single instance of your navigation and have that
reflected in your fifty foreground pages.

Check out this link for more information:

http://office.microsoft.com/en-us/vi...408651033.aspx

Hope that helps.

Best regards

John


John Goldsmith (Visio MVP)
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk

"al" wrote in message
. 2...
=?Utf-8?B?SnVuZVRoZVNlY29uZA==?= wrote in
microsoft.public.visio.general:

Here is an excelent document.
"About Cell References"
http://msdn.microsoft.com/en-us/library/ms195648.aspx

In my test shape name caused error, so I used shape ID.
SHAPETEXT(Pages[Page-2]!Sheet.1!TheText)

Ok, thanks for this! I will try that tomorrow at the office.

What I'm trying to do, is to create "master" elements for wireframes.

I'm very frustrated having eg. navigation element with 15-20 items in
15-50 (or 50..) pages. And when client asks to update navigation or
wants more pages, I have to update all those 50 pages. Same goes with
having annotations in several pages. As being moderately newbie with
Visio, I believe there is an easier way to do this, but this shapetext-
thingy has been very useful for me.

Thanks again.

--
al