I have put a command button on a sheet, and there is code behind it, but I
don't know how to view that code. I have tried going to design mode and
double clicking, but it just runs the procedure. If I'm in the VBA
environment, where do I go to see the code and the properties for a command
button?

I have only a few cells unlocked, so the tab stops go to only those. Is
there a way to make another tab stop on the command button?

Thanks!

--
Jeff Ciaccio
Physics and AP Physics Teacher
Sprayberry High School; Marietta, GA
Blog: http://sprayberry.typepad.com/ciaccio

if it was created with the forms toolbar, just right click on it and choose
assign macro to see what the code is

go to the vb editor to view the code in the module.

if it was created with the control toolbox, then go to the vbe editor and doubl
click the sheet name it resides on under excel objects.

--


Gary


"Jeff Ciaccio" wrote in message
...
I have put a command button on a sheet, and there is code behind it, but I
don't know how to view that code. I have tried going to design mode and double
clicking, but it just runs the procedure. If I'm in the VBA environment, where
do I go to see the code and the properties for a command button?

I have only a few cells unlocked, so the tab stops go to only those. Is there
a way to make another tab stop on the command button?

Thanks!

--
Jeff Ciaccio
Physics and AP Physics Teacher
Sprayberry High School; Marietta, GA
Blog: http://sprayberry.typepad.com/ciaccio

Can I set a tab stop to bring the focus to the button?

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
if it was created with the forms toolbar, just right click on it and
choose assign macro to see what the code is

go to the vb editor to view the code in the module.

if it was created with the control toolbox, then go to the vbe editor and
doubl click the sheet name it resides on under excel objects.

--


Gary


"Jeff Ciaccio" wrote in message
...
I have put a command button on a sheet, and there is code behind it, but I
don't know how to view that code. I have tried going to design mode and
double clicking, but it just runs the procedure. If I'm in the VBA
environment, where do I go to see the code and the properties for a
command button?

I have only a few cells unlocked, so the tab stops go to only those. Is
there a way to make another tab stop on the command button?

Thanks!

--
Jeff Ciaccio
Physics and AP Physics Teacher
Sprayberry High School; Marietta, GA
Blog: http://sprayberry.typepad.com/ciaccio