G
Guest
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'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