Allow | search
Click here to view Allow news from 60+ newspapers.
Bookmark or Share- Change macro security settings in Excel - Microsoft SupportIn Excel, you can change the macro security settings to control which macros run and under what circumstances when you open a workbook. For example, you might allow macros to run based on whether they are digitally signed by a trusted developer.
- Enable or disable macros in Microsoft 365 filesTrust access to the VBA project object model Block or allow programmatic access to the Visual Basic for Applications (VBA) object model from an automation client. This security option is for code written to automate a Microsoft 365 program and manipulate the VBA environment and object model.
- Trusted documents - Microsoft SupportClick the File tab. Click Options. Select Trust Center, and then Trust Center Settings. Click Trusted Documents. Clear the Allow documents on a network to be trusted check box. View or modify Trusted Documents settings in the Trust Center. You can view or change Trusted Documents settings in the Trust Center.
- Create, edit, and manage connections to external dataPower Query for Excel Help. You can use Microsoft Office Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file. By using the Workbook Connections dialog box, you can easily manage these connections, including creating, editing, and deleting them.
- Block or unblock external content in Office documentsClick Options > Trust Center > Trust Center Settings, and then click External Content. There is only one option: Always block the connection of untrusted Microsoft Query files (.iqy, .oqy, .dqy, and .rqy) Check this option if you want to block connections to Microsoft Query files.
More
