Are you sure it's not being activated? Put a "stop" command into the sub as
well and see if it triggers the debugger.

If it's not being run, it might be in the wrong  module/ It needs to be in
the ThisWorkbook module.

If it is being run, but nothing appears to change, then you probably also
need an Application.MoveAfterReturn statement.