Assigning macro to command button

[rlnye]

Hi, I have tried to assign a macro to a command button...but can not find the "assign macro" command when I right click the command button. I have Excel 2000 professional. I've tried help and followed the directions...but still can not find "assign macro"

Any help is greatly appreciated...thanks

 

[smozgur]

Hi,

Are you using VB command button control? If so then you can double click on it in design mode and goto Click procedure then call the macro within this event's procedure.

Or you can use Forms command button control to use Assign Macro in context menu.

Regards
Suat