It is similar to what you do to change your tab’s location. The last Ribbon trick I want to show you is how to integrate with an existing tab. Taking advantage of context-sensitivity is slick and allows you to make efficient use of the UI real-estate. To specify a context, select RibbonExcel and change the Context property.Īfter this change, our custom tab now only displays when the user selects a cell that resides within a table. In essence, the tab is aware that it is only useful under specific contexts and that it should not bother you outside of the context. There are times when your custom Excel tab lacks relevancy and should be hidden from display. That’s all you do, now the tab will conveniently display next to the Home tab during runtime.ĭon’t let your custom tab reside in the far-right side where you users will ignore it. In the property window, set InsertAfterIdMso to TabHome.Select the RibbonExcel tab in the visual designer.If you want to change it to display somewhere else, like after the Home tab, do the following: Select RibbonExcel and use the visual designer to add the following controls and set their properties according the table below.ĭuring runtime, our custom Excel ribbon will display as the last tab on the right-hand side.Just make sure the icons are 32 pixels by 32 pixels. Then add three beautiful and attention-grabbing icons to the Images collection.
Leave the name as is but set its ImageSize= 32,32. Add an ImageList control to the AddinModule. It’s a sin to bore a user with your add-in, so let’s add some icons. Ribbons are bland and boring without icons.Add an ADXRibbonTab and set the following properties: Let’s begin with a custom ribbon that adds a new tab. Let’s build some custom Excel ribbons and some toolbars. Select Excel (and only Excel) as the supported application.Select Office 2003 as the minimum supported Office version.Choose your preferred language (I went with VB.NET, you can choose C# or C+.NET too).To follow along, you need to create a sample add-in project. Let’s not get ahead of ourselves… first things first, you know. Creating custom ribbons for Excel 2013-2007
0 kommentar(er)
