Add Button To Cell Right-Click Menu Excel VBA Macro

[@sharmasudhirdutt]

Very helpful!! thanks!!

[@alexrosen8762]

Very useful! Thank you 🙏

[@MinhNguyen-jw3ln]

Insightful!

[@cajinguy218]

Very helpful! Had to modify script to reset each time if used with Worksheet_BeforeRightClick to prevent continuously adding the same controls repeatedly.

[@jrericksen]

This is great! However, if I am in Page Break Preview mode, the new command does not show. I suspect a different command bar shows, but I cannot determine which command bar is shown when you right-click a cell while in Page Break Preview mode.

[@jrericksen]

Note that I am also trying to use this within a Table (I did get it to work outside of the table)

[@ExcelMacroMania]

@@jrericksen I never used it in a page break preview mode but there might be an index for that cell command bar, I would try with 38 instead of 35,...but there are many other, not sure how to find the one. You can try to do some research in the Microsoft site, I believe I saw there sometime ago the list of all command bars. learn.microsoft.com/en-us/office/vba/api/office.commandbar

[@madalinmd1119]

Imagine we got an xslm file that has a macro somewhere that made all the workbook have an 'Calulcate model' option when we right click on the rows. How can we identify where is it coming from? I even have it on empty new workbooks, it s super persistent.

[@madalinmd1119]

when I try to click it it says that macro could not run due to some error

[@ExcelMacroMania]

@@madalinmd1119 You might have installed some add-in before and is not available anymore.... maybe. Try to locate the add-in in the add-ins folder and/or remove it if it bothers you. If the cell menu still pops-up, you can also delete it targeting the name as follows: CommandBars("Cell").Controls("Calculate model").Delete