How do you password protect a workbook using a password stored and controlled in a central server?

%3CLINGO-SUB%20id%3D%22lingo-sub-2005519%22%20slang%3D%22en-US%22%3EHow%20do%20you%20password%20protect%20a%20workbook%20using%20a%20password%20stored%20and%20controlled%20in%20a%20central%20server%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2005519%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20was%20wondering%20if%20there%20is%20a%20possibility%20to%20store%20a%20string%20in%20a%20text%20document%20in%20a%20central%20server%20so%20that%20when%20you%20open%20an%20excel%20sheet%2C%20the%20password%20typed%20in%20is%20checked%20against%20this%20string.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2005519%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2005645%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20password%20protect%20a%20workbook%20using%20a%20password%20stored%20and%20controlled%20in%20a%20central%20serve%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2005645%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F907998%22%20target%3D%22_blank%22%3E%40DavidGoh%3C%2FA%3E%26nbsp%3B%2C%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20you%20save%20the%20file%20below%20find%20TOOLS%2C%20hit%20then%20U%20find%20General%20Option%2C%2C%20here%20you%20can%20set%20PW%20to%20Open%20%26amp%3B%20Edit%20the%20WB.%20If%20you%20are%20looking%20for%20control%20at%20server%20then%20as%20your%20ADMIN%20to%20set%20rights%20to%20the%20user%20can%20be%20PW%20encrypted%20also.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi all, was wondering if there is a possibility to store a string in a text document in a central server so that when you open an excel sheet, the password typed in is checked against this string.

1 Reply

@DavidGoh ,,

 

While you save the file below find TOOLS, hit then U find General Option,, here you can set PW to Open & Edit the WB. If you are looking for control at server then ask your ADMIN to set rights to the user can be PW encrypted also.