Outlook icon

How to run a macro with parameters from a toolbar button in Outlook 2003

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?

Continue Reading: How to run a macro with parameters from a toolbar button in Outlook 2003 »

Outlook icon

Create Outlook toolbar buttons using VBA

under construction

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 »

Excel icon

Useful toolbar buttons you don't see every day in Excel 2003, Part 3

This is the last post in the Useful toolbar buttons you don't see every day Series. To view previous entries, visit:

Continue Reading: Useful toolbar buttons you don't see every day in Excel 2003, Part 3 »

Excel icon

Useful toolbar buttons you don't see every day in Excel 2003, Part 2

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: Useful toolbar buttons you don't see every day in Excel 2003, Part 2 »

Excel icon

Useful toolbar buttons you don't see every day in Excel 2003, Part 1

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.)

Continue Reading: Useful toolbar buttons you don't see every day in Excel 2003, Part 1 »

Site last updated: February 9, 2012