Buttons and Macros

  • Thread starter Thread starter Salt
  • Start date Start date
S

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?
 
You are possibly using the wrong button.
View>Toolbars>Forms.


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


Mark
 
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.
 
Back
Top