Make a button to activate a macro

[mgasparel]

I need to put a button on my excel sheet to activate a macro... how would i accomplish this?

[whiteliyl_111]

First, make sure your control toolbox is up. If not, go to View > ToolBars> Control Toolbox.

Then click on the command button icon (single raised gray box) > drag/insert on the page you want the button to be on.

Right click on Command button to change Caption (name the user sees on the button).. you can also change Font etc, here.

Right click on Command button to view code.. and paste your macro code in there.

hope that works.

[mgasparel]

Thanks a lot.. that wasnt evry hard at all

[whiteliyl_111]

Very Cool...