I know I've seen this somewhere, but I can't remembeer how
to determine which macro is assigned to a particular button
or autoshape. What's the procedure?

If it's from the form's menu, right click and select assign macro.
dialog box should come up and tell you what is currently assigned.

If the button is from the control toolbox, you must bring up the Visua
Basic menu, and click on the Design Mode button. Then double-clickin
on the button will bring you to the macro.

If you are talking about a button on a toolbar, right click the butto
and select customize. Then right click the button again and selec
Assign Macro. A dialog box should come up and tell you what i
currently assigned.




--
Message posted from http://www.ExcelForum.com

I didn't make myself clear . . . this isn't a Userform. I
have autoshapes and toolbar buttons that I've assigned
macros to. Those are the "buttons" to which I referred.
-----Original Message-----
in design mode right click the contorl: View Code

----- SidBord wrote: -----

I know I've seen this somewhere, but I can't
remembeer how
to determine which macro is assigned to a particular
button
or autoshape. What's the procedure?

.

Thanx loads . . . that's what I was lookiing for.
-----Original Message-----
If it's from the form's menu, right click and select
assign macro. A
dialog box should come up and tell you what is currently
assigned.

If the button is from the control toolbox, you must bring
up the Visual
Basic menu, and click on the Design Mode button. Then
double-clicking
on the button will bring you to the macro.

If you are talking about a button on a toolbar, right
click the button
and select customize. Then right click the button again
and select
Assign Macro. A dialog box should come up and tell you
what is
currently assigned.


K


---
Message posted from http://www.ExcelForum.com/

.