Very helpful! Had to modify script to reset each time if used with Worksheet_BeforeRightClick to prevent continuously adding the same controls repeatedly.
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 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
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 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
Very helpful!! thanks!!
Very helpful! Had to modify script to reset each time if used with Worksheet_BeforeRightClick to prevent continuously adding the same controls repeatedly.
Insightful!
Very useful! Thank you 🙏
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.
Note that I am also trying to use this within a Table (I did get it to work outside of the table)
@@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
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.
when I try to click it it says that macro could not run due to some error
@@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