PDA

View Full Version : Solved: How to protect macro code..



Shane
04-05-2007, 01:45 AM
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
04-05-2007, 01:54 AM
In the VBIDE, Tools>Properties>Protection. It is weak protection, but it is something.

Shane
04-05-2007, 02:03 AM
Thanks done.