Solved

Visio 2013 - the GUARD function

Posted on 2014-07-24
2
840 Views
Last Modified: 2014-07-29
I looked up sites, used the help screen but I am really having a hard time understanding the GUARD function.
Can someone give me a couple simple, kindergarten examples?
0
Comment
Question by:brothertruffle880
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 250 total points
ID: 40219176
The general idea with GUARD() is to prevent a particular cell value from being changed via the user interface (or in many cases by code). For example, draw a rectangle and manually set the fill color to 1 (white) and the fill pattern to 1 (solid). At this point you will be able to change the shape color by using the Fill button on the ribbon. Next, change the value in the fill color cell from 1 to GUARD(1). You will no longer be able to change the fill color using the Fill button.
0
 
LVL 11

Assisted Solution

by:Visio_Guy
Visio_Guy earned 250 total points
ID: 40219283
Guard should be wrapped around a whole formula as well, not just a portion of a formula.

It is generally used in the Shape Transform section and Line and Fill sections. Occasionally also used to lock down a Shape Data value as read-only.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A recent Visio zone question asked how to use the data in an Excel file to create a Visio Gantt chart -- and then to dynamically update the Gantt chart. The good news is that the Viso Gantt Chart wizard can be automated. The bad news is that the…
Book Review: Using Microsoft Visio 2010 by Chris Roth   Disclaimer: The author of Using Visio 2010 is a friend and fellow Visio MVP. Whether you’re new to Visio or are upgrading to Visio 2010 from a previous version, you will find a lot to like…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

705 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