Create Custom Tab in Office Ribbon at Excel/ Word 2007

Mujeeb Rahman

1y78.8k12100Article

12 Comments

Join the conversation! Your thoughts help the community grow.

Naveen Mishra14y ago
Very Good Contents We can create Add ins using VBA code also but for .net developer this is very easy steps Naveen Mishra MS Excel VBA Developer & Trainer for Corporate Training you can contact on 91-9871115570
Remesh CP16y ago
Hi, We have created custom ribbon mentioned in the sample. we are able to see the custom ribbon, in the development machine. Also please let me know how we can deploy the same ribbon dll in end user machine. We tried to create a setup file and install in other machine (Office 2007 installed). But when opening Word 2007, the custom ribbon is not displaying. Please help us to resolve this. Thanks Remesh
- Remesh CP16y ago
  Hi Mujeeb Thanks for your information. As mentioned in your mail, published the project and got the setu.exe with one application folder and one .vsto file. Whne I am trying to install the same in another machine; getting the same issue. (Visual Studio not installed in that machine). Only Office 2007 is available. Please share your inputs, how we can deplloye this in another system in which there is not VS2008/2005. Thanks in Advance Remesh
- Mujeeb Rahman16y ago
  Remesh, In some case the Add-In is found either Disabled ot Not Loaded. If you are not get any error while deployment, please do the following Checking. In Exce/Word, Click Roud Pearl Button -> Slect Word Options (In the case of Word) -> In the Word Option Menu Select Add-Ins Tab -> From the Combo select 'Disabled Items' then Click 'Go..' Button. You can enable the add-in from here(If disabled). Also select COM Add-Ins from combo , It will list all dowload COM Add-In and check whether your Addin is found there or not
- Mujeeb Rahman16y ago
  Please watch this video http://msdn.microsoft.com/en-us/office/bb851702.aspx
divya16y ago
Can you please explain me, how to create a custom ribbon in word, which has brief features of printing a document. It would be helpful if you provide step by step information or sample project.
- Mujeeb Rahman16y agoedited
  Are you expecting the solution in VC++? I can help you only for VB.Net or C# solution. For creating Custom Tab for Word 2007, in Visual studio 2008 create New Project and select Word 2007 Add-in template from office category and follow the same step as described for Excel Add-in(this article). Please have a look on the last screen shot image
aravind16y ago
hai:: I want create a custom task pane that users can hide or display by clicking a toggle button on the Ribbon. You should always create a user interface (UI) element, such as a button, that users can click to display or hide your custom task pane, because Microsoft Office applications do not provide a default way for users to show or hide custom task panes.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Software Used:<o:p></o:p> .net 2.0 and c#,Vsto<o:p></o:p> <o:p> </o:p> Can u give the Steps For that<o:p></o:p>
- Mujeeb Rahman16y ago
  From visual studio 2008 you can easily create a custom task pane Described in this link http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=81717
- Mujeeb Rahman16y agoedited
  I found the link for creating custom Task Panes in the 2007 Office system http://msdn.microsoft.com/en-us/library/aa338197.aspx I didn't try the code in the above link. Please let me know if you have any doubt

Introduction

Customization of Office 2007 applications like Word or Excel is very easy with Visual Studio 2008. Nowadays a day lot of real-time business requirement is accomplished by Office customization. Office ribbon provides rich UI and you can add your own custom tab on it very quickly.

This article describes a step-by-step method for creating a Custom Tab in Excel/Word 2007 at UI Ribbon. The user doesn't need to write a single line of code to achieve the functionality described in this article. All code is automatically generated by Visual Studio 2008 Project Template.

Step-by-step description starting from here.

Step 1. Create a new Excel 2007 Add-in project.

Excel

In the solution explorer, you can see the following image.

This AddIn.cs contains the required method for designer Support.

Designer Support

Step 2. In this step, you can add a new ribbon visual Designer to the project.

Right-click on the Project file->Add -> Select New Item in the Office category -> select Ribbon (Visual Designer).

Visual Designer

In the solution explorer, you can see the RibbonCustom.cs file and also its designer view.

Designer view

Step 3. In the designer view of RibbonCustom.cs, from the box, add a new Tab into the bottom panel of the Ribbon.

RibbonCustom

Step 4. Now, you can see the new tab. From the Properties of the new Tab, you can set your own name and label.

Custom

Step 5. Add your own control to the tab from Tools. Remember that for adding any control first need to add "Group". All controls (like buttons, labels, Gallery, etc) are the child of Group control.

Button

Step 6. Easy Press the F5 button it will build and run one Excel with your custom tab on the ribbon.

Microsoft excel

Cool Right? Please Try it.

How do I publish the setup of this project?

From the Visual Studio toolbar, Click on the Build item, select the Publish ExcelAddinCustom Tab, and follow the wizard. It will create the setup.exe in the selected folder.

Create Custom Tab for Word 2007

Create New Project Select the Word 2007 Add-in template from the office category and follow the same steps as described for the Excel Add-in.

New Project

How to disable the Add-in?

Open Excel file
Click on the Top Left Round Button (Microsoft Office Button)
Click on the Excel Option Button available at the bottom.
From Excel Options Dialog, Select Add-In Tab
Select COM Add-ins From the Manage Combo box, and Click the Go Button.
Uncheck unwanted Add-ins From the COM Add-Ins list

You also get a piece of good information for enabling/disabling office add-in from Here

http://office.microsoft.com/en-us/help/HA100341271033.aspx

How do you permanently remove the Add-in?

Go to Control Panel -> Programs and Features -> Uninstall the setup.