Assaigning a macro to a command button?

[PoloSmith]

Hi.

I have recorded a macro called "Table" and am trying to assaign it to a command button.

In excel help it says to right click on the cmdbutton and go to "assaign macro". There is no assaign macro option in this list.

I have also tried going into VBA and simply putting the macros name in the cmd buttons code - im non too good with VBA in excel.

????

Thanks much

[Charles]

HI,

If you used the "Control Tools" button you can not assign a macro to it. You have to use the "Forms" button to assign a macro to it.

HTH

Charles

[PoloSmith]

Ahhh

Thanks