Applying a macro to a command button, Excel 2002

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!
 
D

Dave Peterson

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

Vicky

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
Command button macro 6
how do you assign a macro to a command button in Excel 2003 5
Assigning a command button to a macro 6
Run a macro from another workbook in the QAT 1
Excel 2007 -- Assign a macro to a button 1
Command Button for Macro on a Toolbar 7

Top