assigning macros

S

scott

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
 
T

Tom Ogilvy

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.
 
G

Guest

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