Stop enabling, stop yelling and pray your husband comes to the realization that it's time to stop, without which he is lost.
Well, that is a tough one. You definitely can empower him and support him, being non-judgemental and understanding. However, there is nothing YOU yourself can do to get him off the pain meds, it truly is something he will need to do on his own accord.