How to transfer UDF to other peoples' machine

[SKV]

I have made some user defined functions and want to share those with other colleagues in my office.

What is the way to send these functions so that they can run from their machines and also how can I hide the code so that they don't mess the code.

Thnx

 

[VoG]

In the VBE, Tools > VBA Project Properties > Protection tab, tick Lock project for viewing and supply a password.

You can then make and distribute an Add-in http://www.fontstuff.com/vba/vbatut03.htm