When you click on the button, click on its border. Around the button,
you'll see a thick dotted border.
(If you click inside the button, you'll see a thick border with diagonal
lines, and you won't be able to assign a macro.)

Right-click on the button border, and choose Assign Macro.


BellExcel wrote:
I have a problem in trying to assign a macro to a button in Excel 2002. When
I create the button, and then click on the button, the "Assign Macro" command
is grayed out (unavailable). I cannot figure out what's wrong.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html