VB Password help

M

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

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.
 
Top