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

Menu Macro Not Executing - Need Help 1
Excel 2007 Command button 3
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
No option to create a list in SharePoint Site 0
Command Button Excel 2007 4
Anchor issue with inserting a shape for letterhead 1
Use Macro To Change Which Macro Assigned To Command Button 0
Command Button- Assign Macro & Sheet Protection problem 1

Top