Excel Macro Security

Question

Hello All,I'm having an issue with Excel Macro security. We have 5 computers at the office on the same network and shared through a OneDrive shared folder.On my computer the Marco’s work no problem, once i open an Excel file with a Marco, a security bar opens to ENABLE. Even though the Marco's created by someone else in my office, i can open and use the macro's no problem.But other computers in my office will not give me the option to ENABLE as you can see below. I've even recreated the file with new macros on anther computer and after restarting Excel i get the SECURITY RISK message.&nbsp;I've tried all the options i found on this community under macro securities, with no prevail.&nbsp;Any help please.ThanksSC&nbsp;&nbsp;&nbsp;

royalton · Answer

Thanks for the reply.I solved the problem, the issue is when an Excel file with macros/VBA are located in OneDrive, the owner of the "OneDrive folder" and the owner of the "Excel file with Marcos/VBA" MUST BE THE SAME.

jkpieterse · Answer

Royalton&nbsp;How *exactly* are you opening the file on the problem computer?

royalton · Answer

Hello Jan,I navigate to the OneDrive folder location on any of the computers and double click the Excel file.Hope i answer your question.

royalton · Answer

Btw, i'm the Admin in my organization, that's why macro's run on my PC but not others, this could be the problom.If this is the issue how do i change the policy in to allow macros?

jkpieterse · Answer

Royalton&nbsp;I'm by no means a Microsoft 365 Admin, but perhaps this thread gives you some pointers?&nbsp;https://www.reddit.com/r/excel/comments/112ahmw/solution_enabling_macros_on_workbooks_from/&nbsp;

Forum Discussion

Excel Macro Security

Share

Resources