Password protect the macro coding

[sindhuja]

Hi,

I want my macro coding to be password protected.
Only i should edit the coding and no read only access to the other users...

Can anyone please provide what should be done to password protect the coding...:doh:

-Sindhuja

[Shane]

In VBE ..
Go to Tools
VBAProject Properties
Click on Protection
Check - Lock project for viewing
and put doen the password.


Regards,
Shane

[sindhuja]

Thanks for the information Shane :friends:

-Sindhuja

[tstav]

sindhuja,
we can't rely too much on the password protection feature of VBA. This protection is very weak and various tools easily downloaded from the Internet would break any such protection in a split second.
If anyone is determined to read (and mess with) our code, they will do it.

Regards, tstav