Hi,

when you put any code into a module, you need to invoke this by calling it.

Here the trigger to fire your code is the change in the column "M" , hence you will fire any code only when this worksheet_change event occurs.