I can't find the command button control object in Excel 2007

R

Raas

In Excel 2003 I created a grading form that has 6 buttons placed on it, with
macros running from each. In 2007 I can't seem to find the button control to
create another button on the worksheet. Anyone point me out of the dark into
the gray, if not the light?
 
T

Teethless mama

Click on Office Button > Excel Options > Customomize > Under Choose Commands
from: select Commands Not in the Ribbon > then select the one you like and
click Add > OK. It will put it on the Customize Quick Access Toolbar and
select from there.
 
R

Raas

I appreciate the effort, but (my fault) I should have been more specific:
I'm looking for the Button Control that can be placed on a spreadsheet and
then have a macro assigned to it. The same kind of button control that
Access uses on forms. I placed the buttons originally in 2003, but can't
find the control in 2007.

It isn't a command, but a control.

Thanks
 
D

Dave Peterson

You can show the developer tab.

Office button|Excel Options|Popular Category|Show Developer tab in ribbon

Then click on the Insert dropdown arrow (to the left of the design mode icon)
 
R

Raas

Thanks to both of you. Got it.!!!


Dave Peterson said:
You can show the developer tab.

Office button|Excel Options|Popular Category|Show Developer tab in ribbon

Then click on the Insert dropdown arrow (to the left of the design mode icon)
Click to expand...
 
Top