How can I set my personal OneDrive as a Trusted Location.
How can I set my personal OneDrive as a Trusted Location.
I want to set my personal OneDrive sync folder as the Office 365 Excel trusted folder.
As Internet-based Excel macro files were restricted this month, I checked the following documents. However, this document does not explain how to do personal OneDrive. The part described below seems to be for business use.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked
Set the Windows internet security zone assignment for OneDrive or SharePoint domains to Trusted Sites. Admins can use the "Site to Zone Assignment List" policy and configure the policy to place https://{your-domain-name}.sharepoint.com (for SharePoint) or https://{your-domain-name}-my.sharepoint.com (for OneDrive) into the Trusted Sites zone.
This policy is found under Windows Components\Internet Explorer\Internet Control Panel\Security Page in the Group Policy Management Console. It’s available under both Computer Configuration\Policies\Administrative Templates and User Configuration\Policies\Administrative Templates.
SharePoint permissions and OneDrive sharing aren't changed by adding these locations to Trusted Sites. Maintaining access control is important. Anyone with permissions to add files to SharePoint could add files with active content, such as macros. Users who download files from domains in the Trusted Sites zone will bypass the default to block macros.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I want to add the synced folder in my personal onedrive to the trusted folder in office 365 to use the excel file with macros.