VBA Code to unprotect VBA Module

[Michael Beckinsale]

Hi All,

Further to a recent post can anybody tell me how you unprotect a VBA Project
in an external workbook using VBA code. I do know the password.

All contributions appreciated

Regards

Michael Beckinsale

[dominicb]

Good afternoon Michael Beckinsale

I don't believe it can be done directly from VBA, whether you know the password or not. You could use the SendKeys command as a workaround, but it's a bit clumsy.

HTH

DominicB

[Bob Phillips]

This has been answered many times before. Here is a typical response from
Harald Staff

Not possible without a little unreliable SendKeys to simulate actual
keystrokes. Search http://groups.google.com/advanced_group_search for
keywords "unprotect project" in group *excel*



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michael Beckinsale" <[email protected]> wrote in message
news:%[email protected]...
> Hi All,
>
> Further to a recent post can anybody tell me how you unprotect a VBA
Project
> in an external workbook using VBA code. I do know the password.
>
> All contributions appreciated
>
> Regards
>
> Michael Beckinsale
>
>