Hi,

is it possible to unprotect a password-protected excel-addin by code or does
the user needs to enter it allways manually? neither the unprotect method of
the coressponding workbook object nor the password-parameter of the "open"
function seems to do what I need :-(

kind regards

It can be done, but it involves the use of SendKeys which isn't too stable.

This is an example, but you may need to tune it

With Application
.SendKeys "%{F11}", True ' VBE
.SendKeys "^r", True ' Set focus to Explorer
.SendKeys "{TAB}", True ' Tab to locked project
.SendKeys "~", True ' Enter
.SendKeys "password"
.SendKeys "~", True ' Enter
End With

--

HTH

Bob

"Berkan" wrote in message
...
Hi,

is it possible to unprotect a password-protected excel-addin by code or
does
the user needs to enter it allways manually? neither the unprotect method
of
the coressponding workbook object nor the password-parameter of the "open"
function seems to do what I need :-(

kind regards