View Single Post
 
Old 11-21-2022, 03:34 AM
milou190 milou190 is offline Mac OS X Office 2019
Novice
 
Join Date: Nov 2022
Posts: 2
milou190 is on a distinguished road
Post how to keep a perfect duplicate of a shape in a visio page

Hi there,
I was asked as part of my internship to make a template with 3 shapes, which will then be used to establish process flows.
The three forms are as follows:
Capture d’écran 2022-11-21 111819.png
these forms are linked to a list of predefined services like engineering, environment, security... and when I change the service in the list, the services are automatically changed in the forms. To do this, I selected the service shape in process shape, then opening the ShapeSheet, I filled in as follows:
HideText =IF(STRSAME(Sheet.1047!Prop.PSERVICE,"Environment" ),FALSE,TRUE)
Capture d’écran 2022-11-21 113050.png
so so far everything is working fine. However, when I duplicate the shape, the formula in the HideText changes. I have :
IF(STRSAME(REF(),"Environment"),FALSE,TRUE)
And then, nothing works.
Capture d’écran 2022-11-21 113703.png
(you can see at the top left of the image the previously duplicated form and we notice that when I change service, the description of the service of the form remains blocked)
Do you have any idea how to help me? Thanks in advance!
Reply With Quote