Though for worksheet and workbook passwords, you can get the
equivalent hashed password using the algorithm found he
http://www.mcgimpsey.com/excel/removepwords.html
Reapplying the same hash leaves the workbook/worksheet password in
the same state - the user will never know you've "changed" it, and
the original password will work fine.
Don't disagree with it defeating the purpose of having a password,
though. <g
In article ,
"Chip Pearson" wrote:
There is no way to retrieve a password with VBA. That would defeat the
purpose of having a password.