Change ActiveX Security Settings : 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 Trust Center. Then click Trust Center Settings.
In the left pane, click Trust Center. Then click Trust Center Settings.
In the left pane, click ActiveX Settings.
           Set the option for ActiveX.
           Disable all controls without notification.
           Prompt me before enabling Unsafe for Initialization controls with additional restrictions 
              and Save for Initialization (SFI) controls with minimal restrictions (default).
           Prompt me before enabling all controls with minimal restrictions.
           Enable all controls with restrictions and without prompting 
              (not recommended, potentially dangerous controls can run).
Enable all controls with restrictions and without prompting (not recommended, potentially dangerous controls can run).








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