Security - Quickly protecting workbook with standard passwords

[latushe]

I know how to protect a workbook in excel. My question is can I have a standard set of passwords that I can setup and then quickly choose a password for a workbook?

I have 20+ customers and I want to password protect excel workbooks using a different password for each customer. The excel files that are created each time I am sending so I need to create a password each time.

I have seen this functionality in adobe where it allows you to create and store several passwords and then choose the password to use on the document.

Is this available in excel?

 

[CalcSux78]

I'd go with either an Add-In or new workbook that generates a customer list and when a selection is made, retrieves the stored password. it can then be added to your code as needed.