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" <(E-Mail Removed)> wrote in message
news:F2896486-2E29-4BE9-A4D5-(E-Mail Removed)...
> 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