hide vba code

[Guest]

hi,

i would like to know if there is a way i can hide the code in a spreadsheet
after i pass it along. and will the code still work if it is hidden?

thanks in advance,
geebee

 

[Dave Peterson]

Inside the VBE
Select your workbook's project
tools|VBAProject Properties|Protection tab

Lock it for viewing and give it a memorable password.

Be aware that this password isn't going to stop the really dedicated--but it
will keep most people out.