I put it in the workbook "Right Click event" as shown in the first line.
Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
I had a lot of them to do and didn't want to keep reaching for a button. I found a right click to be the quickest way to trigger it. You will need to disable it when you are done because it will fire when you right click even if you don't want it to.
You could put the code in any sub you want and run it via more traditional means if you don't mind reaching for a button or pulldown menu.
Gary