hi

i have a piece of code where i need to open various workbooks - these
all have passwords (i know what they are).

what i dont want to do is code in the passwords into my vba as anyone
could look at them and see exactly what they are.

is there a way i can encrypt the passwords in the code?

i dont really want to password protect them as i have a tendancy to
forget them