Macros and SharePoint

%3CLINGO-SUB%20id%3D%22lingo-sub-1576191%22%20slang%3D%22en-US%22%3EMacros%20and%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576191%22%20slang%3D%22en-US%22%3EHi!%20Is%20it%20possible%20to%20save%20an%20excel%20spreadsheet%20(with%20macros)%20to%20SharePoint%20and%20share%20the%20file%20so%20others%20can%20use%20it%20in%20the%20app%20(not%20web%20browser)%20and%20it%20save%20but%20not%20be%20able%20to%20save%20it%20locally%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1576191%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1577587%22%20slang%3D%22en-US%22%3ERe%3A%20Macros%20and%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1577587%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F753792%22%20target%3D%22_blank%22%3E%40Gemmaw1200%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirstly%2C%20you%20will%20probably%20need%20to%20turn%20on%20checkin%2Fcheckout%20on%20the%20document%20library%20the%20file%20is%20in%20to%20stop%20issues%20with%20users%20trying%20to%20save%20it%20at%20the%20same%20time.%20Co-authoring%20will%20likely%20not%20work%20anyway.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20no%20way%20to%20let%20a%20user%20edit%20the%20file%20but%20then%20not%20download.%26nbsp%3B%20There%20is%20a%20permission%20level%20to%20stop%20download%20called%20view%20only%20but%20this%20won't%20let%20them%20edit%20the%20file.%20You%20can%20stop%20them%20syncing%20the%20document%20library%20locally%2C%20which%20is%20a%20setting%20in%20the%20document%20library%20settings.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hi! Is it possible to save an excel spreadsheet (with macros) to SharePoint and share the file so others can use it in the app (not web browser) and it save but not be able to save it locally?
1 Reply

@Gemmaw1200 

 

Firstly, you will probably need to turn on checkin/checkout on the document library the file is in to stop issues with users trying to save it at the same time. Co-authoring will likely not work anyway. 

 

There is no way to let a user edit the file but then not download.  There is a permission level to stop download called view only but this won't let them edit the file. You can stop them syncing the document library locally, which is a setting in the document library settings.