I can't find the Assign Macro command

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
You used a commandbutton from the Control toolbox toolbar.

Delete that one and add a button from the Forms toolbar.
 
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
 
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

Command Button Excel 2007 4
Assigning Macro to a Command Button 3
losing command button functionality 4
Assigning a command button to a macro 6
How to assign macro coding into customized button? 4
Assign a macro to Command Button Object 2
Access Automatically Send a notification email once a record is added 0
Command button macro 6

Back
Top