Solved

Displaying/Hiding One Object Based Upon The Data In Another

Posted on 2007-11-23
4
243 Views
Last Modified: 2008-02-01
In Visio, one can define custom data fields on an object.

Let's say that I have two objects:  Object_A and Object_B.  Object_A has a user-defined variable: Var1.

If Object_A.Var1 = 0 then don't show Object_B.  Otherwise, show it.  

The actual showing/hiding can be accomplished via the object's transparency setting, but I don't know how to have one reference the other outside of writing a macro.
0
Comment
Question by:bmclaugh
  • 2
4 Comments
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
ID: 20377193
You can do this in the shapesheets for the two objects and there's a better way than messing with transparency.

Item 1: In the shapesheet, look for the section called Geometry1. The first row includes a field called Geometry1.NoShow. If the value in this cell is FALSE, the shape appears; if TRUE, the shape doesn't appear on the page.

Item 2: You can refer to another object on the page using its name and an exclamation point (!). Consequently, "Prop.Var1" refers to the shape data field called "Var1" in the current shape, but "Object_B!Prop.Var1" refers to the field called "Var1" in the shape called "Object_B".

Combining Item 1 and 2:

In the shape sheet for Object_B, put the following formula into Geometry1.NoShow:
     =IF(Object_A!Prop.Var1=0,TRUE,FALSE)

Stated in English: If Var1 in Object_A = 0, NoShow in Object_B is set to TRUE and Object_B is invisible; if it's any other value, NoShow is FALSE and Object_B is visible.
0
 
LVL 30

Expert Comment

by:Scott Helmers
ID: 20503054
Did my previous answer solve your problem? If so, I would appreciate it if you would accept the answer and award the points. If not, let me know what additional information you need (for example, if you're not familiar with the Visio shapesheet, or need help getting the formula to work).

Thanks,
Scott
0
 
LVL 1

Expert Comment

by:Computer101
ID: 20658526
Forced accept.

Computer101
EE Admin
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever created a custom Visio stencil – a collection of your own unique master shapes – and then created a drawing by dragging masters onto the drawing page? Have you then made changes to the stencil master and wondered why the shapes on the …
Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now