Solved: How to protect macro code..

[Shane]

Hi!

I have created a macro which takes the data from sheet one calculate it and then shows the result in sheet two.. I did a VBA code for that . Now the point is I am about to send that macro to my friend fir testing purpose. What I need is that my friend cannot see the coding that i did. he can only insert the values in Sheet 1 basis which calculation needs to be done and result will display in sheet 2.

Pls help

[Bob Phillips]

In the VBIDE, Tools>Properties>Protection. It is weak protection, but it is something.

[Shane]

Thanks done.