Add page #'s to shapes in the org chart

[Julie]

We are creating a multiple page org chart using the visio wizard. Some pages
show one level of subordinates and the following pages show the rest of the
organization by department. For example, the 1st page shows 3 directors
reporting into a VP and the 2nd page shows the 1st director and their
reports, 3rd page shows the 2nd director and their reports, etc.

I would like on the 1st page to show the pages the directors can be found
on. For example, on the 1st page in/below the 1st director's box it will say
page 2, on the 1st page in/below the 2nd director's box it will say page 3,
etc.

Is there a way to generate these pages #'s automatically?

 

[WapperDude]

Have you considered using hyperlinks instead of the "text" approach? Adding
hyperlinks avoids cluttering your document, and, when you click the shape,
the pop-up menu allows you to click the link and takes you to the desired
page. The Visio help is pretty good on this.

I haven't used the Wizard enough to know if you can automate this thru the
Wizard, kinda doubt it. It ought to be possible to write some VBA code to
automate the steps, but, I've not done that either.

Wapperdude

 

[Julie]

Thanks for the information. However, we print multiple copies of our org
charts to be distributed to different employees in our company. Therefore,
hyperlinks will not work for those that only receive printed copies.

Does anyone have any other suggestions as to how we can include the word
"page" and then the page number under their box to show what page they (and
their organization) will appear on?

 

[WapperDude]

Here's a possible approach, and kills 2 birds with 1 stone.

Instead of the hyperlinks, use the offpage connector from the Basic
Flowchart Shapes stencil. Placing these on the drawing will allow jumping to
the desired page in Visio, and, you can add text to the shape, such that
hardcopies will indicate where to go.

One way to add text is via the insert Field, custom formula, entering:
"Page:" & CHAR(10) & Hyperlink.OffPageConnector.SubAddress.

This will display the text, "Page:" (without the quotes), and next line will
show the page name. Most of this can be done using the macro recorder. Some
additional code will be needed to instruct the macro as to where to drop each
shape.

I'm sure there are other ways, but, this struck me as reasonably simple.

HTH
Wapperdude