set min size of a shape

[Jack Zhong]

Is there a min size of a shape? If not, I would like to add such a
property to a shape, so it would not change its size when the width or
height value is less than a specified value when the end user resize
the shape later on.

best regards,

Jack

 

[Chris Roth [MVP]]

Hi Jack,

This formula works in the Width and Height cells:

=BOUND( ,1,0,-1 in,1 in)

Some notes:

- The first argument is left out because that is simply the current value
for the shape and will be written-in by Visio.
- 1in is the minimimum size
- the "1" means exclusive bounds - the shape can not be between -1in and
1in.
- I put "-1in" in as the lower bound because 0in didn't work quite right -
you could not be between 0 and 1in, but you could be exactly 0in, which was
not good. You could put in "-0.0001in" too, I guess.

--
Hope this helps,

Chris Roth
Visio MVP

Free Visio shapes:
http://www.visguy.com/category/shapes
Visio programming info:
http://www.visguy.com/category/programming/
Other Visio resources:
http://www.visguy.com/visio-links/

 

[Jack Zhong]

Thank you, Chris.

Jack

 

[John Marshall, MVP]

You are stuck Bound these days. ;-)

You can also use MIN()

John... Visio MVP

Need stencils or ideas? http://visio.mvps.org/3rdparty.htm
Need VBA examples? http://visio.mvps.org/VBA.htm
Visio Wishlist http://visio.mvps.org/wish_list.htm