Visio - I need the field name for sheet - the USER ASSIGNED NAME.

I would like to have the name of the sheet appear in a text box on my diagram.

I used the name() function but it returned SHEET.45.  What I wanted was the name I assigned to the sheet (Omaha Network).

I already am using FILENAME() and DIRECTORY().
brothertruffle880Asked:
Who is Participating?
 
Scott HelmersConnect With a Mentor Visio Consultant, Trainer, Author, and DeveloperCommented:
If the sheet you're referring to is the page itself and the name you want is the name on the page tab, then I think the function you're looking for is PAGENAME().
0
 
Visio_GuyCommented:
Hi BT,

If the shape has a non-generic name, then NAME() will return something non-sheet-like, e.g.: PC.48, as you've already seen.

You can then use the ID() function to get the numeric part, ie: the 48 in this example. Since "Sheet" is a given, there is no ShapeSheet function that returns the whole "Sheet.48". But you can concatenate:

= "Sheet." & ID()
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.