Depends on how complex you need it to be
one approach would start here :

http://www.rondebruin.nl/ado.htm

Ron's site will show how to read and write to closed workbooks

so you could have one workbook with all passwords
and have all other workbooks "look" here for verification "read from closed
master password file.

"HeinerMeiner" wrote:

Hello all!

I've created several workbookswhich all have the same password protection
via VBA code and an inputbox. is it possible to put those passwords in
another workbook - the master password workbook - ? In the case of a change
in the passwords I have to open and edit all workbooks manually. Or is there
any other way not to change the passwords in every single workbook