If you want a button in the spreadsheet, then you need the "Control
toolbox" button. Open "control toolbox", click command button, draw the
button, r-click the button, View Code, paste the macro contents into the
"click command"

Rich D wrote:

OK. I managed to get the smiley face command button on the toolbar and
assigned the macro to it. Now...how do I get my button or smiley face with
the macro attached down someplace on my worksheet? It won't click & drag.