Hi all, I am somewhat familiar with VBA, but I am new to office script - so please be patient with me.
I am seeking to create an organigram for teams of variable sizes and compositions. I have a table of names and roles, which populate specific elements in the organigram (the structure of which is fixed). However, as the teams are of variable size the tool is meant to remove elements from the organigram which are not in use/vacant. The easiest way to do that is to set transparency to 100. Question: Is there a way for Office Script to go through the list of object names in a table and set the transparency to 0 or 100 depending on a simple boolean parameter? As I cannot wrap my head around how to do this, any help is appreciated.
Thank you very much in advance!
I am seeking to create an organigram for teams of variable sizes and compositions. I have a table of names and roles, which populate specific elements in the organigram (the structure of which is fixed). However, as the teams are of variable size the tool is meant to remove elements from the organigram which are not in use/vacant. The easiest way to do that is to set transparency to 100. Question: Is there a way for Office Script to go through the list of object names in a table and set the transparency to 0 or 100 depending on a simple boolean parameter? As I cannot wrap my head around how to do this, any help is appreciated.
Thank you very much in advance!