Macro command problem

J

johncouzins

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

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

Is there any other way i can assign a macro?


Cheers



Joh
 
F

FSt1

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
 
D

Dave Peterson

You have another response at your post in .excel.
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
Click to expand...
 
J

johncouzins

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

cheers anywa
 
D

Dave Peterson

What didn't work?

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