VB Password help

[May]

Hi
I created an excel spreadsheet that uses VB Macros. How
do I set up a password so that other people using the
report can not go into Visual Basic and mess with the
coding?

 

[J.E. McGimpsey]

in the VBE, Tools/VBAProject Properties/Protection, check the Lock
Project for viewing checkbox and supply a password.

Note, however, that there are cheap commercial crackers out there
that will remove such protection, and your code can be read largely
intact in a hex editor.