Applying a macro to a command button, Excel 2002

  • Thread starter Thread starter Vicky
  • Start date Start date
V

Vicky

I have done this in 2003. Create a command button, macro list appears (or
right click and assign macro)

In 2002 I dont see the same options. I was able to create a regular
rectangle shape and apply the macro to that. Any thoughts?
THanks!
 
There are two buttons that look alike.

One button is from the Forms toolbar that has the behavior you want and the
other is a commandbutton from the Control toolbox toolbar (and it works works
differently).

I bet you used the one you didn't want. Remove the commandbutton and replace it
with the button from the Forms toolbar.
 
Errrr - Is this the same in 2003?

Dave Peterson said:
There are two buttons that look alike.

One button is from the Forms toolbar that has the behavior you want and the
other is a commandbutton from the Control toolbox toolbar (and it works works
differently).

I bet you used the one you didn't want. Remove the commandbutton and replace it
with the button from the Forms toolbar.
Click to expand...
 

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
Access Automatically Send a notification email once a record is added 0
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
losing command button functionality 4
Command button macro 6
Alt+F11, writing macros and assigning to a button 2
Run a macro from another workbook in the QAT 1

Back
Top