Dec 20 2020 06:18 PM
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.
Dec 20 2020 08:13 PM - edited Dec 20 2020 08:15 PM
@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.