Toolbar button to run a VBA macro

M

Myrna Larson

I have written a VBA macro in Publisher 2003 that makes some formatting
changes. It works fine.

I would like to create a toolbar button that I can click to run this code.
How do I do that?

I am familiar with customizing toolbars in other Office apps: In Excel, on
the Commands tab, there is a Macros category, and it contains the commands
Custom Menu Item and Custom Button. I don't find that in Publisher.

If I try to copy another button with the intention of changing its function,
when I right-click the copied button, there's nothing on the menu that
allows me to attach a macro to the button.

And I also don't find a way to assign a keyboard shortcut key to the macro.
Is that possible? How?

Thanks for any help.
 
E

Ed Bennett

Whilst attempting to develop brick-based storage technology, Ed reads a
message from Myrna Larson said:
I would like to create a toolbar button that I can click to run this
code. How do I do that?

Come in to microsoft.public.publisher.programming and I can help you with
this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top