http://support.microsoft.com/?id=167909
XL: Securing Visual Basic Code in Microsoft Excel

http://support.microsoft.com/?id=156942
XL97: How to Create an Add-in File in Microsoft Excel 97

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

http://msdn.microsoft.com/library/en...xceladdins.asp

http://msdn.microsoft.com/library/en...exceladdin.asp

http://www.j-walk.com/ss/excel/tips/tip45.htm
Excel 97: Creating Add-Ins

You addin should delete any existing version of the toolbar and create a new
version when it is loaded. It should also mark it as temporary and delete it
in the beforeclose event. The creation can be done in the workbook_open
event of the addin.

If the user will only load the addin when they want to use it, then this
should be sufficient. If they will load the addin all the time, then it
depends on the user. In tools=Customize, they can select whether the bar
is visible or not. If that is too hard, then perhaps you could provide a
function in your addin that they can run from Tools=Macro=Macros or you
can add an additional menu choice in the tools menu.

--
Regards,
Tom Ogilvy



"HSalim[MVP]" wrote in message
...
How do I create an add-in and distribute it to others?
I have a toolbar associated with the add-in. The user wants the toolbar
to
be invisible most of the time. When she wants to use the add-in -
approximately once a month, she will make the toolbar visible.
What is the best way to achieve this?
Thanks
Habib