Buttons and Macros

[Salt]

Excel 2002

I'm trying to place a button on a spread sheet that will
clear selected cells. I can make the button and write the
macro, but I can't tie them together. In HELP it tells me
to click on the button, right click, and click on "Assign
Macro" in the shortcut menu. My short cut menu shows:
Cut
Copy
Paste
Properties
View Code
CommandButton Object
Grouping
Order
Format Control

I can't find "Assign Macro". Does anybody know how to do
this?

 

[Robert Nguyen]

Use the button from the Form Menu (View-Tool bars-Forms)

 

[sh0t2bts]

You are possibly using the wrong button.
View>Toolbars>Forms.


Select the button off here and all should work fine..


Mark

 

[Don Guillett]

To modify a command button, you must be in design mode. Hassle. Just use a
button from forms or a shape from drawing and you will be a happy camper.