At least I would ask you to confirm that the task cannot be solved from within Excel.
This is not the same as saying Excel can't do it, but I couldn't get it to work. The Ribbon button handler never even seems to fire


I put a breakpoint there

I added a "Stop"

I added a "Beep

I used .Statusbar = ...


Nothing seems to happen