hi,
on the controls toolbar click design. Right click the button and select view
code for the pop up menu. here you should be able to assign your macro. you
may be able to paste the entire macro or if you have already writen the
macro you can use the call command ie
sub button_click()
call Yourmacro
end sub

Regards
FSt1

"johncouzins" wrote:


I am trying to assign a macro to a command button. The only way i know
how to do it is to insert a command button and then when i release the
mouse the "assign button" should come up. But its not doing it for some
reason.

And when i try to copy and paste the code into the button it brings me
up a load of errors.

Is there any other way i can assign a macro?


Cheers



John


--
johncouzins
------------------------------------------------------------------------
johncouzins's Profile: http://www.excelforum.com/member.php...o&userid=25602
View this thread: http://www.excelforum.com/showthread...hreadid=390509