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

No Takers?

I have to rotate vbe project password every 90 days. Is there a way to
automatically update a large number of Excel VBEs with one macro. They all
should have a common password. Or I am stuck doing this manually one
workbook at a time?

Thanks,

Daniel

"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

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