I can't find the Assign Macro command

G

Guest

I am trying to assign a Macro that I recorded to a command button. However
when I right click on the sizing bar of the command button "Assign Macro"
does not appear. Is thare another way to do this?
 
D

Dave Peterson

You used a commandbutton from the Control toolbox toolbar.

Delete that one and add a button from the Forms toolbar.
 
P

PCLIVE

I'm not sure if there is anything against doing this (as I've been doing it
this way for some time), but you can go to 'View Code' and then just type
the name of your macro. That should run your macro when the button is
clicked.

HTH,
Paul
 
D

Dave Peterson

Personally, I like the buttons/controls from the Forms toolbar for most things.
I find that they're "lighter" than their counterparts from the control toolbox
toolbar.
 

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

Similar Threads

Assign Macro 7
Command Button Excel 2007 4
button to run macro 6
Assign a macro to Command Button Object 2
Assign to macro missing 3
Command button macro 6
Assign Function to a Command Button 1
Command button 1

Top