http://support.microsoft.com/default.aspx?kbid=211563
How to create an add-in file in Excel 2000

http://msdn.microsoft.com/library/de...ificaddins.asp
Building Application Specific Add-Ins

http://msdn.microsoft.com/library/de...xceladdins.asp
Excel Add-Ins

http://msdn.microsoft.com/library/de...slibraries.asp
Add-ins, Templates, Wizards, and Libraries


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ups.com...
I have created a Private Function which accepts 9 parameters from the
user. I don't want to show this function to anybody. How can I create a
password protected addin out of this function so that users can install
that addin and use this function only by supplying the parameters
without having access to the vba code.