If you have User-defined cells called, say, Group1, Group2, Group3, etc.;
then you could set the Invisible cell of several cells to, say, =User.Group.
Set thier values to 0.
Then you can have an Action cell with the formula
=SETF(GETREF(User.Group1),NOT(User.Group1)), and you can set the Checked
formula to =User.Group1 , etc
Then you can control the visibility of many custom properties by toggling
the value of a User cell.
Post by Vissie
On Nov 13, 6:20 am, JuneTheSecond
Post by JuneTheSecond
In the shapesheet, each row of custom-prop has a cell named as InVisible.
My idea is to add Action cell, and write at 1fs line as
SETF(GetRef(Prop.Row_1.Invisible),TRUE) in action cell, and
"!st Prop Invisiobel" in Menu cell.
At 2nd line
SETF(GetRef(Prop.Row_1.Invisible),FALSE) in Action cell, and
"!st Prop Visiobel" in Menu cell.
Then user can display menues by right clicking and can control visiblities.
Thanks for the reply June.. I tried it and the making it Invisible
part works but it doesnt make it Visible again, have checked the
formulas, they are as you gave them. Any ideas ?
Also I was wondering how its possible to modify the formula
SETF(GetRef(Prop.Row_1.Invisible),TRUE) in Action cell so that
collectively a group of properties can be made Invisible/Visible with
one right click, rather than have lots of action cells for each
Thanks a million !