Macro not trigger on cell value change

Originally Posted by jeetusaini85

The another macro is mentioned below. This macro basically for update the status records.

I don't see any line of code to enter text "yes" in cell in your another macro.

Then how the worksheet change code will run?