Forum Discussion
Excel Macro Security
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.
I've tried all the options i found on this community under macro securities, with no prevail.
Any help please.
Thanks
SC
- JKPieterseSilver Contributor
Royalton How *exactly* are you opening the file on the problem computer?
- RoyaltonCopper ContributorHello Jan,
I navigate to the OneDrive folder location on any of the computers and double click the Excel file.
Hope i answer your question. - RoyaltonCopper ContributorBtw, 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?- JKPieterseSilver Contributor
Royalton I'm by no means a Microsoft 365 Admin, but perhaps this thread gives you some pointers? https://www.reddit.com/r/excel/comments/112ahmw/solution_enabling_macros_on_workbooks_from/