•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Macros blocked on Sharepoint
Our take
Are you facing challenges with macros blocked on SharePoint? One user has created a workbook with VBA code that runs perfectly on their laptop, yet encounters errors when accessing it from a secure SharePoint page. With a highly restricted IT environment, they’ve found themselves unable to add trusted locations or enable macros. The question arises: is there a workaround to allow macro functionality, or will the team need to resort to using the file without the vital code? Share your insights and solutions!
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Excel macros work locally but not properly from SharePoint (data validation errors)Hey everyone, I’m troubleshooting an Excel (.xlsm) file stored in SharePoint that relies on macros, and I’m running into a confusing issue. Originally, users were getting the standard macro block error: “Microsoft has blocked macros from running because the source of this file is untrusted” As a test, I copied the file locally (outside of SharePoint), and everything worked perfectly — macros ran with no issues. However, when using the file from its SharePoint location (via OneDrive sync), things don’t behave the same: The macro block error is no longer showing But users now get this error when entering data: “This value doesn't match the data validation restrictions defined for this cell.” It feels like the macros are only partially running or something isn’t fully initializing when the file is opened from SharePoint. To clarify: The file must remain in SharePoint (we can’t rely on local copies) The goal is to have users open and use the file directly from the SharePoint/OneDrive synced location Other teams in our organization have similar macro-enabled files working from SharePoint, so this should be possible At this point, I’m not sure if this is: A macro trust/security issue (still partially restricted?) A data validation dependency that isn’t loading properly Or something specific to how the file was built Questions: Can macros fully run from SharePoint/OneDrive synced locations, or are there limitations? Has anyone seen data validation errors like this caused by macros not executing fully? What’s the proper way to make this work — trusted locations, macro signing, or policy changes? Appreciate any guidance — this one’s been tricky to pin down. Thanks! submitted by /u/Icy-Alternative-3860 [link] [comments]
- Visual Basic Error when using MacrosHello Community, we got some excel file with macros from an agency we work with. On domain users in our network it brings this error: Microsoft Visual Basic for Applications File not found: C:/users/(username)/appdata/local/temp/*.tmp Those files mostly begin with VB*.tmp This error doesn´t occur on local users / domain-admins I have already worked through all excel gpos regarding macros and safety. I have already marked the file as safe and also the network directory in which it is stored. It also will not work when saved locally with a domain-user (it only worked once) Maybe someone can help me. Thanks in advance! submitted by /u/Maleficent-School762 [link] [comments]
- Macro running on all workbooksFirst. I’m really not an Excel expert so please explain things slowly. I regularly download a report that has a lot of raw data. I need to rearrange and rename columns and delete others that aren’t pertinent to my task. I tried creating a macro to help with this. I simply clicked record macro, saved it in a new workbook, made the formatting changes, end recording. When I went to run the macro I find it’s changing the formatting of other workbooks I have open as well. Obviously that creates a huge problem. Question: How do I create a macro that I can save on my computer and share with others so the formatting of this report can be quick and easy? submitted by /u/SubmarineScreenDoor9 [link] [comments]
- Personal Macro Workbook Missing on Mac OSI started working on something and all my macros are gone, and when I went to take a look at my personal macro workbook it's gone - unhiding doesn't do anything. I know I have fixed this in the past - I think it just got disabled somehow but I can't figure out how to see it in VBA or anywhere else - does anyone using excel on a mac recall how to fix this? Any help would be very much appreciated! submitted by /u/whateverbitch11 [link] [comments]
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