Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: Visisthebest on October 01, 2021, 09:05:09 AM

Title: Guard on the shape data format field
Post by: Visisthebest on October 01, 2021, 09:05:09 AM
If I put a Guard on the shape data format field, if the user doesn't access the shapesheet is there any other way they can change a lookup list (that is in the format field)?
Title: Re: Guard on the shape data format field
Post by: Surrogate on October 01, 2021, 09:35:11 AM
The user can use the code to change the content protected by the Guard function, FormulaForce (https://docs.microsoft.com/en-us/office/vba/api/visio.cell.formulaforce) can do this.

Of course i mean advanced user  ;)

Title: Re: Guard on the shape data format field
Post by: Visisthebest on October 01, 2021, 09:53:44 AM
Thank you Surrogate yes not worried about that one, but good to know it is possible.
Title: Re: Guard on the shape data format field
Post by: Surrogate on October 01, 2021, 02:06:06 PM
Quote from: Visisthebest on October 01, 2021, 09:53:44 AM
but good to know it is possible.
You need protect or way how change without open ShapeSheet window ?  ;)
Title: Re: Guard on the shape data format field
Post by: Visisthebest on October 01, 2021, 03:19:49 PM
I assume the user does not go in to the shapesheet, warn the user in the manual no to.