One thing I have seen on several jobs that I was called in to fix was the guy would build his macros using the record button then add any fixes or tweaks using the ir database so that when I changed any equipment say fios to spectrum I would have to look at all the macros and key assignments for any that he dragged and dropped from the database because those would not change by changing the code set.
One thing I have learned in this industry. It is easier to pull a wire than it is to push one.