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

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" wrote in message
...
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

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

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=39125