Solved

Visio 2013 - the GUARD function

Posted on 2014-07-24
2
749 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
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Scott A. Helmers Partner, Harvard Computing Group Microsoft Visio MVP Background Microsoft has added more enhancements and new features to Visio 2010 than to any release since they purchased the Visio product line in 2000. In addition, the com…
The ability to add structure to Visio diagrams using containers, lists and callouts is one of my favorite features in Visio 2010. In this article we’ll examine containers. We’ll explore lists (http://www.experts-exchange.com/Microsoft/Applications/M…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

772 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