How do to disable button "Insert cut cells" by ribbon on Excel 2007?

partnerex_dev
partnerex_dev used Ask the Experts™
on
1. What's "control name"  of button "Insert cut cells"?
2. I want to disable button "Insert cut cells" by ribbon on Excel 2007.

Help me?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
RibbonCustomizer  is a third-party tool/Add-In for Office 2007 that allows full customization of   the ribbon interface: tabs,  buttons, sort order, etc.

The Free  Starter Edition allows you to add groups to tabs and customize  the ribbon dialog.

The Professional edition is a fully-featured 30 day trial (license - 30$). The program integrates well with Office 2007 and has a  easy to use interface. It can customize commands for  each tab, add or remove entire tabs, add/remove groups within each  tab etc.

Download Page

Note: you can also customize your office/Excel 2007/2010 if you have programming knowledge (XML) .. See this tutorial
Most Valuable Expert 2011
Top Expert 2011
Commented:
I'm not sure you can and if you could, I don't think you'd want to necessarily. In theory that button is the CellsInsertDialog button (that's what you get if you copy it to the QAT) but in practice disabling that button has no effect on the 'Insert Cut Cells' button. And I can't find any mention of the ID for that button in the MS documentation (or in Ron's files). I suspect you might have to hide the entire group and build your own without any controls you don't want - you may not be able to include the Insert Cells button at all though.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial