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

 

[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)

 

[dominicb]

Good afternoon Michael Beckinsale

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

HTH

Dominic