Thursday, June 14, 2012

How to Add ActiveX Control in Excel 2007


1. Open the Microsoft Excel 2007 application from your computer and then click on the “Microsoft Office” button.
2. Click on the “Excel Options” button and then click on the box next to the “Show Developer tab in the Ribbon” field. Click on the “OK” button.
3. Click on the “Developer” tab and then click on the “Insert” option from the “Controls” group. Click on the “More Controls” option below the “ActiveX Controls” group.
4. Click on the ActiveX Control that you want to add from the list of controls in the More Controls dialog box.
5. Click the location on your worksheet where you want the ActiveX control to appear. The control will then appear in your worksheet.

Blogger news