Sample VB6 project for creating an Excel Addin with a button?

[Michael]

I want to create an XL-Addin so I can distribute to some friends. I don't
want them to be able to view the source code so here are my options:



a.. Use the XLVeryHidden property for the sheet (Not a smart choice
because it can be changed from VBA)
b.. Add a password to my VBA code (Not a smart choice either because
anyone can crack this - info available on the internet)
· Create an XLA addin. (This is NOT a good idea because XLA add-ins
are NOT safe. A few simple VBA commands is all it takes to convert an XLA
back to its original XLS. To make it more difficult, I could protect the
sheets on my workbook with a password before creating an add-in. Even then,
it's possible that the password can be broken by someone who knows the
secret. Bottom line? XLA is not the same as an encrypted file.)

What I want is some sample code that allows me to create An Excel Addin.
When I load this Add-in it should have a button that says Send E-mail. I
have narrowed down all the logic behind this button using VBA but I can
convert it in other languages (if needed). Any ideas? Does someone have a
sample Excel-Addin project?

Thanks in advance
Michael

 

[Michael]

I actually decided that what I really want is to create an Excel COM Add-In
using a VB6 .dll. I found this article
http://support.microsoft.com/kb/238228/ so I plan to work with it.

Thanks
Michael

 

[RB Smissaert]

Another option (and maybe that is easier) is to make a normal .xla add-in,
but
put all the relevant code in a VB6 ActiveX dll.

RBS