11.3.4.Set ActiveX Control Properties |
|
Click the Office button, and then click Excel Options.
|
|
![Click the Office button, and then click Excel Options.](../../Microsoft-Office-Excel-2007Images/Set_Activex_Control_Properties___Click_Office_Button_And_Then_Click_.PNG) |
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.](../../Microsoft-Office-Excel-2007Images/Set_Activex_Control_Properties___In_Left_Pane_Click_Popular_Select_S.PNG) |
Click the Developer tab. Click the Design Mode button.
|
|
![Click the Developer tab. Click the Design Mode button.](../../Microsoft-Office-Excel-2007Images/Set_Activex_Control_Properties___Click_Developer_Tab_Click_Design_Mo.PNG) |
Select the control. Click the Properties button.
|
|
![Select the control. Click the Properties button.](../../Microsoft-Office-Excel-2007Images/Set_Activex_Control_Properties___Select_Control_Click_Properties_But.PNG) |
To switch controls, click the Controls list arrow.
|
|
![To switch controls, click the Controls list arrow.](../../Microsoft-Office-Excel-2007Images/Set_Activex_Control_Properties___To_Switch_Controls_Click_Controls_L.PNG) |
Click the Alphabetic or Categorized tab to display the control properties.
|
|
![Click the Alphabetic or Categorized tab to display the control properties.](../../Microsoft-Office-Excel-2007Images/Set_Activex_Control_Properties___Click_Alphabetic_Or_Categorized_Tab.PNG) |
Click the property box for the property. Type the value.
|
|
![Click the property box for the property.](../../Microsoft-Office-Excel-2007Images/Set_Activex_Control_Properties___Click_Property_Box_For_Property.PNG) |
Or click the arrow and then click a value in the list.
|
|
![Or click the arrow and then click a value in the list.](../../Microsoft-Office-Excel-2007Images/Set_Activex_Control_Properties___Or_Click_Arrow_And_Then_Click_Value.PNG) |
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.](../../Microsoft-Office-Excel-2007Images/Set_Activex_Control_Properties___Or_Click_Dialog_Button__To_Open_Dia.PNG) |
Click the Design Mode button again to exit.
|
|
![Click the Design Mode button again to exit.](../../Microsoft-Office-Excel-2007Images/Set_Activex_Control_Properties___Click_Design_Mode_Button_Again_To_E.PNG) |