•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Macros blocked on Sharepoint
Hi! Was wondering if anyone has a solution.
I've created a workbook with some VBA code in it. Runs fine on my laptop. When I try to open it from a secure SP page the macros won't run and I get a error message. The file works fine on open SP-pages.
Our IT environment is Very locked down, so even though I've managed to get access to security center I'm not able to add trusted locations or enable macros in those settings.
Is there a workaround or do I just have to make my team use the file without the code?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#no-code spreadsheet solutions
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#macros
#SharePoint
#VBA
#error message
#workbook
#secure SP page
#IT environment
#trusted locations
#security center
#workaround
#enable macros
#locked down
#open SP-pages
#team