I used this method but when i try to unlock the password, the error msg
"Object variable or With block variable not set" appeared. Pls help.

TQ

"Iain A C T" wrote:

Thanks for your help I havenow managed to fix the problem.

Cheers

"DNA" wrote:

Not sure if this is the correct site, but give it a try.

http://www.mcgimpsey.com/excel/removepwords.html

HTH