This is a routine that has worked lots of times for others.

My guess is that the code got fouled up when you copied|pasted.

I'd go back to that site and get a fresh copy.

If that still doesn't work, include the line that caused the error.

S.CYJ wrote:

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



--

Dave Peterson