Identifying Macros called by Toolbar Buttons

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Walter K. - 17 Mar 2005 17:53 GMT

How do you identify which macro is called by a toolbar button after the
button name has been shortened or renamed (in Word 2003)?

Over the years our office has developed numerous macros called by toolbar
buttons. The button names have been changed and don't identify the specific
macro name. Often we have different versions of a macro and I can't identify
which version of a macro is called by a specific toolbar button on each
computer. While I could insert a message box statement into each macro that
would display the macro name when run, this would be very laborious for the
50 - 60 macros we are using.

Signature

Walter Klein

Reply to this Message

Jonathan West - 18 Mar 2005 00:58 GMT

Hi Walter,

The macro called by a toolbar button is identified by the button's OnAction
property.

Unfortunately, you need to write a VBA macro in order to read the Onaction
property of a button...

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

> How do you identify which macro is called by a toolbar button after the
> button name has been shortened or renamed (in Word 2003)?
[quoted text clipped - 10 lines]
> the
> 50 - 60 macros we are using.

Reply to this Message

Walter K. - 18 Mar 2005 14:35 GMT

Thanks Jonathan;
I was hoping for a simpler answer but I'll see if I can write the code to
retrieve the OnAction property.

Walter K.

> Hi Walter,
>
[quoted text clipped - 18 lines]
> > the
> > 50 - 60 macros we are using.

Reply to this Message

Rate this thread: