Prev: Why does saving take SOOO long?
Next: Can I 'toggle' a toolbar button
From: Berkan on 7 Jun 2010 04:36
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
From: Bob Phillips on 7 Jun 2010 05:05

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" <Berkan(a)discussions.microsoft.com> wrote in message
news:F2896486-2E29-4BE9-A4D5-6F54BDD84DAB(a)microsoft.com...
> 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


 | 
Pages: 1
Prev: Why does saving take SOOO long?
Next: Can I 'toggle' a toolbar button