Control Toolbox

I need to assign a macro to a command button that was created using the “control toolbox”. Can anyone help me with this? If you right click on the button a list of selections pops up, one is properties, if you click properties you can see the properties for the button but there isn’t an event tab like in Access database. In Access you just assign a procedure in one of the events. I can do it using the Forms tool bar but I have a spreadsheet that was passed on to me with “command buttons’ made from the “controls toolbox” and I need to know what macro is assigned to which button and how to assign a different macro. Thanks for the help in advance.

Hi... try adding the DEVELOPER tab to the ribbon, then click on DESIGN, and double click the button in question. It should open in your VB Editor to any coding sitting behind that particular button.
Good luck!

Thanks for the help JP. I don’t know what the “ribbon” is or how to add the developer tab to it. Can you explain that a little more? Thanks again for your help.

Apologies - I assumed you were using Excel 2007....
I see shg's here, so I'll back down (it's usually good advice to let the smarter people take the helm!)

Yea I must apologize, I forgot to declare which version I am using, which is 2003. Thanks for the info shg, I see how it’s done now. And thanks everyone that responded.