I have recorded which protects worksheets and the workbook with passwords.
The macro is stored in the Personal workbook. When I run the macro against
another workbook it runs ok but the passwords aren't embedded.

What have or done wrong or is this not possible. Looking at the the VB there
is no ref to password or encrypted data there.

Thanks