Mar 03 2023 09:00 AM
New Computer Microsoft 11 pro. New Windows 365 subscription
Use OneDrive to access files.
Excel files open but do not have "Enable Access" button which I'm used to.
The Warning on the Files that have Macros say: SECURITY RISK Microsoft have blocked macros from running because the source of the file is untrusted. There is a "Learn More" button but no "Enable Access" button.
I've tried the Trust Center,
Adding onedrive as a trusted Location
Changing macro settings to Enable VBA macros (only temporarily to see if it would work) which it didn't.
I also tried enabling macros 4.0 that didn't work. I do not think the macros is that old
Mar 03 2023 09:03 AM
Mar 03 2023 09:04 AM
Mar 03 2023 09:42 AM
Mar 03 2023 09:47 AM
Mar 03 2023 09:52 AM
Mar 03 2023 09:54 AM - edited Mar 03 2023 01:04 PM
The issue is with a stricter Microsoft macro security setting. I've seen this same issue with several clients over the past few weeks. Usually clearing the author name or even wiping a workbook's metadata is enough to fix the issue.
Mar 03 2023 12:43 PM