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