Re: How to run VBA function from custom toolbar?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jezebel (dwarves_at_heaven.com.kr)
Date: 08/18/04 

Date: Thu, 19 Aug 2004 07:57:10 +1000

Right-click any toolbar. Select customise. Select the Commands tab. Select
Macros from the Categories list. Select the macro you want from the Commands
list: click and drag to the toolbar or menu. Initially it will appear on the
toolbar or menu as a fully qualified name. Right click to change this to a
caption or use an icon.

You need to do extra work through VBA if you need to set the command's
Parameter or Tag properties.

For a macro to appear in the commands list it must be public and must not
take arguments.

"kiln" <kiln@brick-like.com> wrote in message
news:MPG.1b8d4c77ff8e31bc9898b7@msnews.microsoft.com...
> I'm used to programming in MS Access. With it, it's simple to run a user
> defined function from a custom toolbar. While in the "Customize" mode
> for toolbars, the first command item in the File list is "Custom", and
> dragging it onto a toolbar creates a toolbar button that has a
> Properties page, where a function can be called. I can't find anything
> like this in Word 2000. It must be possible to call user defined
> functions from a Word toobar, so how it is done?
>
> Thanks

Quantcast