I'm not sure what code you used, but this one also uses Sendkeys:

http://groups.google.co.uk/group/mic...297bf61460daa6

(From Bill Manville)

or
http://tinyurl.com/bf3kb

Maybe you'll get luckier with this code--but I wouldn't rely on anything that
uses Sendkeys.

Daniel wrote:

Good afternoon,

I've looked and found some code which uses the SendKey method to unprotect
vbe projects.... However, I can't get them to work. I am trying to get code
so that I can open a "ChangePwdWb.xls" ,then open 1 or many workbooks, run a
"ChangePwd" function that would prompt, me the user, for the old and new pwd,
unprotect each vbe project associate to each workbook and then change their
pwd to the new one.

Can someone please guide me please. If possible, cut it into small enough
chuck so that I can hopefully understand.

Thank you,

Daniel

--

Dave Peterson