I'm lost <lol!!

I was doing so well, too!! I created the macro I needed.
I created the button and that seemed fine. I set it so
that it won't move with cells, etc., but what I can't find
is how to assign the macro.

I chose the "Command Button" option from the "Control
Toolbox". I don't know if this was the right button as
this wasn't specified but it seemed the best one. But
maybe that's what's wrong (?).

When I right-click, there is no "Assign Macro" option.
If I double-click the Command Button I go into the VB
editor (or what looks like that to me) but I can't seem to
figure out how to assign the previously saved macro to
this button?

[A question re the button, can we put an icon on the
button like we do the ones on the toolbar? I like to
create my own, etc.]

Lastly, I never figured out what you meant by "drag to the
toolbar". The button stays within the rulers of the Excel
spreadsheet and refuses to go "outside" of that area onto
any toolbar.

Again, I think I'm doing something wrong!

Thanks for all this so far, though, Jason! I've learned a
lot.

Cheers!

-----Original Message-----
Add a "Button" to the spreadsheet. Right click on the
ToolBar and choose Control Toolbox.
You will see the button there. Drag it to the toolbar.
Then add the button to the spreadsheet.
Right click the button and choose, Assign Macro.

Tip:
You may want to go into Format Control and under the
Properties click Dont move or size with cells..

Hope this helps..


Jason
.