Which Macro Is Assigned to a Button

  • Thread starter Thread starter SidBord
  • Start date Start date
S

SidBord

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.
 
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.
 

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

Back
Top