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

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

You have another response at your post in .excel.

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

--

Dave Peterson

nope that aint worked, and as i said when i just insert code it goes
wrong. I think that i must be sumthing to do with my network. have to
take it home and do it. Boooo

cheers anyway


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

What didn't work?

Using a button from the forms toolbar or you code when you clicked on that
button?

johncouzins wrote:

nope that aint worked, and as i said when i just insert code it goes
wrong. I think that i must be sumthing to do with my network. have to
take it home and do it. Boooo

cheers anyway

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

--

Dave Peterson