The site formerly known as Code For Excel and Outlook
February 1, 2010 by · 
If you work with Command Bars in Excel, or write add-ins for Excel 2003 that add custom menu options, you'll need to know various properties such as their names. A basic subroutine would look like this:
Continue Reading: List all Command Bar Properties in Excel »
November 23, 2009 by · 
Warning: Toolbars may be under construction. Just kidding.
You can create toolbar buttons using a bit of VBA programming in Outlook's VB IDE. I've adapted some code found at Ken Slovak's site so you can programmatically create buttons on the built-in toolbars, or a custom toolbar you've created.
You can set the button's Caption (the actual text appearing on the button), the Tool Tip (the text that appears when you hover over the button), the name of the macro that runs when the button is clicked, the name of the toolbar where the button should appear (defaults to Standard), and the Face ID of the button.
Continue Reading: Create Outlook toolbar buttons using VBA »
Site last updated: February 9, 2012
Follow Me