TRAPPING PRESSED BUTTON
 

How do I set up some code so that I can trap the Id/Name of the
toolbar button that the user has just pressed.

Also how do I set up some code so that when the user presses a custom
button the Face of the button changes?

any help greatly appreciated

Jason

TRAPPING PRESSED BUTTON
 

Commandbars.ActionControl returns the button that was pressed.

If you store the faces as pictures on a worksheet, then you can copy the new
face and paste it to the control using PasteFace.

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel


"jason" wrote in message
om...
How do I set up some code so that I can trap the Id/Name of the
toolbar button that the user has just pressed.

Also how do I set up some code so that when the user presses a custom
button the Face of the button changes?

any help greatly appreciated

Jason