Set ActiveX Control Properties : ActiveX Control « Macro ActiveX Add in « Microsoft Office Excel 2007 Tutorial






Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
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 Developer tab. Click the Design Mode button.
Select the control. Click the Properties button.
Select the control. Click the Properties button.
To switch controls, click the Controls list arrow.
To switch controls, click the Controls list arrow.
Click the Alphabetic or Categorized tab to display the control properties.
Click the Alphabetic or Categorized tab to display the control properties.
Click the property box for the property. Type the value.
Click the property box for the property.
Or click the arrow and then click a value in the list.
Or click the arrow and then click a value in the list.
Or click a dialog button (...) to open a dialog box to select options.
Or click a dialog button (...) to open a dialog box to select options.
Click the Design Mode button again to exit.
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 macrosShow Developer tab in the Ribbon: access developer controls, write code, or create macros
11.3.2.Insert ActiveX ControlsInsert ActiveX Controls
11.3.3.Using ActiveX ControlsUsing ActiveX Controls
11.3.4.Set ActiveX Control PropertiesSet ActiveX Control Properties
11.3.5.Deal with an ActiveX Control Security AlertDeal with an ActiveX Control Security Alert
11.3.6.Change ActiveX Security SettingsChange ActiveX Security Settings