TM1 Forum

Hi Expert,

I need to color differently the cells in a websheet depending if the cell is updatable or not.
I wish I can write a websheet command to find the STATUS of the cell (same logic as write clicking on it- Edit Status, which gives me cell is editable or not).

Thank you
micheline

If it's done by rule then your stuffed, unless it is controlled by some kind of flag. If it's security based you can always pull in the control cube values and format the cells based on those values and then hides those rows / sheets,

Jim.

Thanks Jim.
Yes, some fields are by rules, some are by security in the control cube, and
Some are by security at the dimension level (like Actuals are read only)

I tried to put a flag, but I have many user types. way too many flags!
Thanks for trying. I hoped the problem was already solved!