assigning macros
 

Hi,
Can someone help me out? I'm trying to assign a macro to
a command button and can't figure out how to do it. In
Excel 97, there was a spot where you could assign a
macro. Can't find it on Excel 2003. Any thoughts?
Thanks in advance.
Scott

assigning macros
 

Sounds like you are confusing Commandbuttons from the Control toolbox
toolbar and buttons from the forms toolbar. For commandbuttons from the
control toolbox toolbar, In Excel 97 and later versions, in design mode,
right click on the button and select view code. This will show you the
click event associated with the commandbutton. This event is fired when the
commandbutton is clicked.

--
Regards,
Tom Ogilvy

scott wrote in message
...
Hi,
Can someone help me out? I'm trying to assign a macro to
a command button and can't figure out how to do it. In
Excel 97, there was a spot where you could assign a
macro. Can't find it on Excel 2003. Any thoughts?
Thanks in advance.
Scott

assigning macros
 

Thanks Tom!
That was what I was doing - I really need to take a class
on excel ;-)
Thanks again. You solved my problem!
Scott

-----Original Message-----
Sounds like you are confusing Commandbuttons from the
Control toolbox
toolbar and buttons from the forms toolbar. For
commandbuttons from the
control toolbox toolbar, In Excel 97 and later versions,
in design mode,
right click on the button and select view code. This
will show you the
click event associated with the commandbutton. This
event is fired when the
commandbutton is clicked.

--
Regards,
Tom Ogilvy

scott wrote in
message
...
Hi,
Can someone help me out? I'm trying to assign a macro
to
a command button and can't figure out how to do it. In
Excel 97, there was a spot where you could assign a
macro. Can't find it on Excel 2003. Any thoughts?
Thanks in advance.
Scott



.