Insert ActiveX Controls : ActiveX Control « Macro ActiveX Add in « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Macro ActiveX Add in
3. ActiveX Control

Click the Office button, and then click Excel Options.

In the left pane, click Popular. Select the Show Developer tab in the Ribbon.

Click the Developer tab. Click the Design Mode button.

Click the Insert button arrow, and then click the ActiveX control.

Drag to draw the ActiveX control.

To resize the control, drag and move a resize handle (circles).

To add Visual Basic code to the ActiveX control, click the View Code button.

Click the Design Mode button again to exit.

11.3.ActiveX Control
	11.3.1.	Show Developer tab in the Ribbon: access developer controls, write code, or create macros
	11.3.2.	Insert ActiveX Controls
	11.3.3.	Using ActiveX Controls
	11.3.4.	Set ActiveX Control Properties
	11.3.5.	Deal with an ActiveX Control Security Alert
	11.3.6.	Change ActiveX Security Settings