Posts Tagged ‘CommandBars’
Excel 2016 crashes if COM add-in creates a command bar control in a built-in context menu
Andrei Smolin | December 7th, 2017
Today's blog is about a recent crash reported by our customer. Our research shows that the crash occurs if your VSTO add-in or COM add-in creates a command bar control on a built-in context menu. We reproduce the crash when customizing the Cells context menu in this way... Read the rest of this entry →
Customizing the Excel User Interface: What is and isn’t customizable
Ty Anderson | September 25th, 2013
Anytime Excel runs into a business process, users discover they require more of Excel. They can have more too by extending Excel via its API. Today, I'll cover what you user interface customizations are available to you when developing Excel add-ins with Add-in Express... Read the rest of this entry →
Creating a custom ribbon for Outlook 2013, 2010 and toolbar for Outlook 2007, 2003 – C# sample
Pieter van der Westhuizen | May 21st, 2013
The Outlook UI provides a lot of customization options, but one thing almost all Outlook add-ins share is either a ribbon tab or a toolbar or two. The Ribbon UI was introduced in Office 2007 although only the Inspector windows actually used it. The Explorer window still used the traditional menus and toolbars from previous Outlook versions... Read the rest of this entry →
How to customize context / right click menu of Excel 2013, 2010 and lower: C# sample
Dmitry Kostochko | August 22nd, 2012
Right-click menus of Microsoft Office applications are a very convenient option for the end-user to interact with the host application. And for us, COM add-in developers, creating a custom menu for our users could be just a piece of cake... Read the rest of this entry →
Creating add-ins for Outlook: custom ribbon & command bar in one project (C#, VB.NET)
Ty Anderson | July 5th, 2012
Despite what some promulgate as software development best practices, I like to start my projects by sketching what I envision. I don't conduct interviews. I don't write requirements. I thumb my nose at all type-A project manager types and don't make a plan... Read the rest of this entry →
How to intercept clicking an Office Ribbon control or command bar button
Andrei Smolin | February 27th, 2012
There are three ways to invoke a command of an Office application: click a built-in Ribbon button (2007-2010); click a built-in CommandBar button (Office 2000-2003 and some Office 2007 applications) and press a keyboard shortcut... Read the rest of this entry →
Excel shapes events: getting notified about user actions
Andrei Smolin | February 21st, 2012
The Excel object model doesn't have any events purposed for manipulations with shapes. In this blog I demonstrate an approach to solving this problem... Read the rest of this entry →
Video: Create an Office shared add-in – connecting business logic to Office events
Ty Anderson | January 26th, 2012
On Tuesday we published Part 3 of the end-to-end demo. Today, we have Part 4. In reality parts 3 and 4 can be taken together but we thought it's better to break them up a bit and provide a bit of a break. But we have momentum now so let's keep this train a-moving because Part 5 is almost ready for its debut as well.... Read the rest of this entry →
How to navigate through the Microsoft Office Command Bar system
Andrei Smolin | January 16th, 2012
There are 4 instances of the command bar button "Save" (Id=3) in Excel. Two of them are best known: a button on the Standard commandbar and an item in the File menu. The other two instances are buried in the command bar system... Read the rest of this entry →
How to handle Outlook item’s Reply event: replying from a context-menu
Andrei Smolin | December 14th, 2011
Let's consider the case then the user replies to an Outlook e-mail from the context menu. First off, you can reply to one item only; that item is selected or right-clicked in an explorer window or is opened in an inspector window.... Read the rest of this entry →
How to create a custom event when Excel calculation mode changes
Andrei Smolin | December 5th, 2011
You should be aware that no such event exists. Let's create it. In Excel 2007 - 2010, you can change the calculation mode using the buttons shown in the screenshot below... Read the rest of this entry →
Outlook and Word Toolbars mixed: problem and solution
Andrei Smolin | November 17th, 2011
Have you ever run into the issue when an Outlook toolbar created by your add-in shows up in Word? Or maybe, a Word toolbar gets displayed in Outlook? This article describes the issue and provides a workaround; the source code is supplied in VB.NET, C# and Delphi... Read the rest of this entry →
How to specify account for an outgoing Outlook message
Andrei Smolin | August 1st, 2011
How to specify account for an outgoing email message in Outlook 2000-2010?... Read the rest of this entry →
How to customize Office 2010 and 2007 Ribbon with your own tabs or controls
Pieter van der Westhuizen | March 22nd, 2011
In today's post I'll demonstrate how you can insert your own ribbon tabs (for Office 2007-2010) and controls (for Office 2000-2003) before or after Office's built-in tabs or controls. I'll also show you how you can add an existing built-in Office control to your own ribbon tab... Read the rest of this entry →
100% version neutrality for your Office extensions
Pieter van der Westhuizen | December 13th, 2010
Finally, when you completed your add-in, there is no need to build separate setup programs for different versions of Office. Generating a setup program is as simple as right-clicking your project in the Visual Studio Solution Explorer and selecting Create Setup Project from the context menu... Read the rest of this entry →
Outlook context sensitivity: show custom UI for certain folders and items types
Pieter van der Westhuizen | December 1st, 2010
Add-in Express makes it possible to display your custom UI elements based on various Outlook components. Elements such as toolbars, toolbar controls, ribbon tabs, ribbon tab controls or Advanced Form Regions can be hidden or displayed based on what the user is doing in Outlook at any given moment... Read the rest of this entry →