search

ClimberMel / SMF_Add-in

Stock Market Functions for Excel using VBA
https://climbermel.github.io/SMF_Add-in/
14 stars 5 forks source link

Office 365 blocks macros #14

Closed ClimberMel closed 1 year ago

ClimberMel commented 1 year ago

Sidney Marder Feb 7, 2023, 12:37:25 PM (5 days ago) to SMF Add-In Just subscribed to Office 365 was using Excel 2011. When I attempt to add it the add in dialogue box gives me a security notice that " Microsoft has blocked macros from running because the source of this file is untrusted"

Any thoughts on what the problem is and how to resolve it greatly appreciated Thanks

ClimberMel commented 1 year ago

Hi Sidney, have you found a solution for this yet? It can be unblocked in Office 365. I have included a link with some instructions, but if that is too confusing, let me know and I can probably get you working again.

https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked#prepare-for-this-change

Cheers, Mel Pryor

ClimberMel commented 1 year ago

I have posted this on the blog SMF Add-In blog It can be addressed in changing security settings in Excel 365 to allow macros.