How do I assign a macro to a command button in Excel 2003?

Question

It used to be easy in Excel 4

Answer 1

First, make sure that you insert the command button with the command button from the Control Toolbox toolbar instead of the Forms toolbar. Then right-click the command button and select View Code. Then in the window that pops up, just paste your macro code in.

Once you are done, turn the edit mode off by clicking the Exit Design Mode button on the Control Toolbox toolbar. The button looks like a little drafting triangle. Use it to turn design mode off and on.

Answer 2

Assign Macro To Button Excel