"Doesn't work" is not enough information.  I already tried setting up such a macro with Comcast remote before posting the suggestion, so I know that it should work in principle. Please check if the LED lights are flashing when the macro presumptively switches device mode.  If not, try setting up a simple macro first, perhaps on a different button.  If the LEDs do flash, use a digital camera (e.g. your phone) to look at the output of the IR transmitters.  Cameras are sensitive to the IR, so you'll see flashes if signals are actually being sent.