(I will not regurgitate the technique for adding items to the context menus using VBA or the Custom UI Editor – Ron explains it very effectively.)
Where is the tools menu in excel 2016 code#
To find a more efficient solution, I looked up a piece of code at Customizing Context Menus in All Versions of Microsoft Excel, written by Ron de Bruin. I think it’s this extra cognitive effort that slows me down, not just the number of clicks involved.