Custom Office Programming and Automation
Previously we showed how to add a toolbar button to Outlook programmatically, and use it to call a procedure that creates meetings from emails (a la the Meeting Reply button in Outlook 2010).
But our procedure has 60 minutes hardcoded as the duration of each appointment. Sure, you can always change it manually, or add another InputBox to the procedure, but what if you want to be able to pass the duration as a parameter?
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.
In Part One of Excel Toolbars You Don't See Every Day, we looked at a few commands you may have forgotten about, which can easily be added to any toolbar in Excel 2003. Let's continue by looking at the Tools menu and the hidden gems offered there.
Continue Reading »
In the next few posts I'll be exploring some of the more interesting Excel 2003 toolbar buttons you may have forgotten about, or not known existed.
(See Useful toolbar buttons you don't see every day in Outlook 2003 for the Outlook version.)
Copyright © 2013 Jimmy Peña · Hosted by FutureQuest · Powered by Genesis · Legal
Follow Me