In previous versions of excel you had a toolbar for inserting controls into a
spreadsheet. Does excel 2007 have the same facility?

Click the Office button (in the top left corner)
Select Popular on the left hand panel.
Check the "Show Developer tab in the Ribbon" item and then click OK.

This will add a Developer tab to the Ribbon.
The second group, controls, contains an insert button which gives access to
Forms and ActiveX controls.

Aren't you glad that 2007 is so much easier to use?


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"davecampbell" wrote in message
...
In previous versions of excel you had a toolbar for inserting controls
into a
spreadsheet. Does excel 2007 have the same facility?

It is in the Developer TAB.

To have it, click the Office buttonExcel OptionsPopularcheck mark
in the "Show Developer tab in the Ribbon" item .

This will add a Developer tab to the Ribbon. Select it and click the Insert
icon in the Controls section. You can insert the desired controls from here
i.e. from ActiveX controls or Form Controls.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Free addins Office Menu-2003 for Office-2007)
If You Can't Excel with Talent, Triumph with Effort.



"davecampbell" wrote in message
...
In previous versions of excel you had a toolbar for inserting controls
into a
spreadsheet. Does excel 2007 have the same facility?

Many thanx

"davecampbell" wrote:

In previous versions of excel you had a toolbar for inserting controls into a
spreadsheet. Does excel 2007 have the same facility?