Maybe you're in Text Edit mode on the button.
Click on the worksheet, to deselect the button.
Then, right-click on the button, and Assign Macro may be available.


Barb Reinhardt wrote:
I have created a Button in my worksheet using the button on the FORMS
toolbar. When I try to add a macro to it, ADD MACRO is greyed out. There
are plenty of macros in the workbook. What am I missing?

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