Set ActiveX Control Security
Excel workbooks may contain ActiveX controls that execute code or respond to macros. ActiveX controls may be digitally signed and are marked by the publisher as to whether they are safe to initialize and safe to script. In this case, safe means that the control will not harm the user’s system.
Whether Excel will download or run any new ActiveX control is determined security by settings in Internet Explorer. To see these settings in Internet Explorer:
From the Tools menu, select Internet Options and click on the Security tab.
Select the location that is the source of the ActiveX control and click Custom Level. Figure 26-21 shows the ActiveX security settings for the local intranet location.
Figure 26-21. Changing ActiveX security settings
As a rule, you should never install unsigned ActiveX controls from any location. ActiveX controls are software, and you should always be careful when choosing which publishers to trust.
Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
