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

Posted on 2010-04-08
Medium Priority
Last Modified: 2012-05-09
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?
Question by:partnerex_dev

Accepted Solution

akjain earned 1000 total points
ID: 30101223
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
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 1000 total points
ID: 30103055
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.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question