Windows/User Authentication for Excel Workbook

[Dinesaaa]

Hey Guys,

I have some 200 excel workbooks with password protected.
Whenever i/my team wanna open this workbook need to be given the password, Is it possible to give some windows/User authentication for those specific excel sheet to bypass the password protection ?


Dinesh S

 

[mole999]

you might encode all the books with specific user ENVIRON strings that you have worked out > https://www.techonthenet.com/excel/formulas/environ.php plus other references on the web