Macro Workbench-How to Automatically Fix a Cell if it's value is changed

[Former Member]

Hello All,

I have a request that while in the Planning Book if a user makes a change to a certain cell we want the Macro to immediately 'Fix' the cell.

I have experimented with ROW_VALUES_CHANGED, but by definition this is fixing the entire row.

See below I am anticipating putting a test in the if statement to see if the cell changes and if true I would apply the fixing settings as shown below.

Can anyone provide recommendations?

[former_member187488 · Accepted solution]

Hello,
I created a wiki page on this topic. Please let us know if you're interested in this kind of page.
BR, Ada

[former_member187488]

Hi,

Have a try with macro function VALUE_OF_ROW_CHANGED(), specifying proper column.

Best Regards,
Ada