command button

[jiemei1]

I have a command button on my worksheet not User form.

I should be able to link the button to any Marco but can't do it on my new computer. Any one know why? I am using Excel 2003.


Thanks

 

[SkipVought]

What kind of a command button?

FORM or Control Toolbox.

FORM: right click - select assign macro

Control Toolbox: double click and observe a plethora of EVENT code structures.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[jiemei1]

Thanks, I neet to click the Design Mode button first to view "Command" button(from Control Toolbox) code.

 

[SkipVought]

Are we cookin' now?

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}