Password to access code

[Corey]

Is there a simple code I can add to prevent someone accessing code in a workbook, by placing a password on it?
Corey....

[Chip Pearson]

Corey,

In VBA, go to the Tools menu, choose VBA Project Properties, then
the Protection tab. Check the "Lock project for viewing" check
box and assign a password. Note, however, that the protection is
very weak and there are any number of tools available for easily
breaking the password.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Corey" <coreytroy@exemail.com.au> wrote in message
news:ucLvX7ZkGHA.1324@TK2MSFTNGP04.phx.gbl...
Is there a simple code I can add to prevent someone accessing
code in a workbook, by placing a password on it?
Corey....

[Corey]

Thanks,
will try it shortly.

Does this mean i could possibly access a lost p/w code in another sheet
through here?
"Chip Pearson" <chip@cpearson.com> wrote in message
news:uxwEFLakGHA.3484@TK2MSFTNGP03.phx.gbl...
> Corey,
>
> In VBA, go to the Tools menu, choose VBA Project Properties, then the
> Protection tab. Check the "Lock project for viewing" check box and assign
> a password. Note, however, that the protection is very weak and there are
> any number of tools available for easily breaking the password.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
> "Corey" <coreytroy@exemail.com.au> wrote in message
> news:ucLvX7ZkGHA.1324@TK2MSFTNGP04.phx.gbl...
> Is there a simple code I can add to prevent someone accessing code in a
> workbook, by placing a password on it?
> Corey....
>