View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default How to set a tab stop for a command button

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