Excel on Microsoft 365 Macros not working

Question

New Computer Microsoft 11 pro.&nbsp; New Windows 365 subscription&nbsp;Use OneDrive to access files.Excel files open but do not have "Enable Access" button which I'm used to.&nbsp;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.&nbsp; There is a "Learn More" button but no "Enable Access" button.&nbsp;&nbsp;I've tried the Trust Center,Adding onedrive as a trusted LocationChanging 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&nbsp;help please&nbsp;

susanne- · Answer

trying to create a pdf file in Microsoft excel

patrick2788 · Answer

Go to File | Info | Properties | Advanced Properties. Clear the 'author' name. Save the workbook and then close/re-open.

amberb6 · Answer

That did not work.

patrick2788 · Answer

Options | Trust Center | Trust Center Settings | Trusted docs - try clearing the Trusted Cache.

amberb6 · Answer

That did not work.I need to have the files in OneDrive as they are shared by another user with me. However when I copy the file onto my desktop I get a new security warning. SECURITY WARNING Macros have been disabled. With an Enable Content button. When clicked the macros works.So the problem is somewhere between OneDrive and Excel?Hope that extra info helps you come up with a solution

Forum Discussion

Excel on Microsoft 365 Macros not working

Share

Resources