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

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?

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

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.


"Raas" wrote:

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?

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

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


"Teethless mama" wrote:

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.


"Raas" wrote:

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?

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

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)

Raas wrote:

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?

--

Dave Peterson

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

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


"Dave Peterson" wrote:

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)

Raas wrote:

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?

--

Dave Peterson