Thread: Assign Macro to Command Button

How do I assign a macro to a command button in Excel 2003. Previously it was
just a right-click away, but not any more

Thankx

Hi adamaagard

You have add a button from the control toolbox instead one from the forms toolbar.

This button have a click event.
Double click on the button when you are in design mode and
enter the macro name in the click event

--
Regards Ron de Bruin
http://www.rondebruin.nl


"adamaagard" <adamaagard@discussions.microsoft.com> wrote in message news:2C4EBACE-AB01-451B-BD8F-745CD1396512@microsoft.com...
> How do I assign a macro to a command button in Excel 2003. Previously it was
> just a right-click away, but not any more
>
> Thankx

Hi,
i have xp but:
- for a CommandButton from the Control Toolbox toolbar, say CommandButton1,
you have to create an event sub in the sheet (or userform) containing the
control:
Private Sub CommandButton_Click( )
End Sub
- for a Button from the Forms toolbar, Right-Click on the button and choose
Assign Macro from the pop-up menu.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com>


"adamaagard" wrote:

> How do I assign a macro to a command button in Excel 2003. Previously it was
> just a right-click away, but not any more
>
> Thankx