Password Protect VB Project

[Blue Dragon]

Hi,
I've got a macro that writes VB into a module in a separate project (i.e. one on a separate workbook).

How can I password protect this 'new' project using VB?

Hope someone out there can help. ray:

 

[TommyGun]

How can I password protect this 'new' project...

Short answer...you can't.

 

[Blue Dragon]

I don't suppose there's a long answer where I can?

 

[TommyGun]

Maybe...but I've never seen it.

 

[Richie(UK)]

... well, the long answer involves the use of SendKeys.

Two points on this:

1. If you want the details do a search as it has been covered a number of times before.

2. It is not a 100% reliable method and many 'pros' would frown upon its use. Its certainly not an approach that you should use in anything that will be used by people other than yourself.