I'd like to be able to pin the ribbon tabs to stay on the current tab
when working on a task.

For example, if you are working on autoshapes with the formatting tab
open, then click a worksheet cell, it will revert back to the Home
tab. I'd like to be able to pin the formatting tab. A VBA solution is
preferred, but a manual solution would work as well.

Thanks,

Nick