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

Copper Contributor

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.