Excel 2007 - insert button, checkbox, combo box etc.

T

TomasZ

Does anyone could help me?
In Office 2003 Forms toolbar contained all these things but I cannot
find it in Office 2007.
 
H

Harlan Grove

TomasZ said:
Does anyone could help me?
In Office 2003 Forms toolbar contained all these things but I
cannot find it in Office 2007.
Click to expand...

You have to enable the Developer tab in the Oh So Wonderful ribbon.
You'll need to click on the oversized Office logo button in the upper
left corner, click on the Excel Options button to display the Excel
Options dialog. You should be in the Popular section, but if not,
click on Popular in the list in the left hand side of the dialog. Once
in the Popular section, check 'Show Developer tab in the Ribbon',
which is the 3rd checkbox down from the top. Then click the OK button.
Simplicity itself.

In the Developer tab in the Controls section there's a drop-down menu
labeled Insert. That's where the form and ActiveX controls are.

FYI, this is a bad choice of newsgroup for application-specific
information. You'd be better off using Excel-specific newsgroups like
microsoft.public.excel or microsoft.public.excel.misc,

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.excel

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.excel.misc
 
T

TomasZ

Harlan said:
You have to enable the Developer tab in the Oh So Wonderful ribbon.
You'll need to click on the oversized Office logo button in the upper
left corner, click on the Excel Options button to display the Excel
Options dialog. You should be in the Popular section, but if not,
click on Popular in the list in the left hand side of the dialog. Once
in the Popular section, check 'Show Developer tab in the Ribbon',
which is the 3rd checkbox down from the top. Then click the OK button.
Simplicity itself.

In the Developer tab in the Controls section there's a drop-down menu
labeled Insert. That's where the form and ActiveX controls are.

FYI, this is a bad choice of newsgroup for application-specific
information. You'd be better off using Excel-specific newsgroups like
microsoft.public.excel or microsoft.public.excel.misc,

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.excel

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.excel.misc
Click to expand...
Thank you very much. I missed that m.p.excel somehow:-(
 
R

rbutler6

I have the developer on the ribbon but it dosen't have an insert any
where on it. sorry I found it thanks
 
Top