Add-in with excel

[Bob]

Hi all:

I would like to write a macro in excel. However, since my code is
proprietary, I do not wish users to see my macro code. From what I
understand, this cannot be done in excel, except password protect it, which
obviously can be broken. Therefore, the only other way that I think this is
possible is to use an "Add-in". However, I have no idea on how to develop
such a code or process. I was wondering if any one can give me some pointer
on how to do this, or guide me to some good and easy to follow books.
Thanks for all your help.

Bob

 

[bmurphy]

From the excel user interface go File/Save As and in the dialog
select "add-in" as the file type. This will save the file with an XLA
extension.

Then go to VBA and in the Project tree right click on the file and
select Properties. In here set "Lock for viewing" and give it a
password.

This is as secure as you can make it in Excel. But readily available
Office password crackers can defeat this. The casual user, however,
won't be able to see your code.

To make it really secure, I believe you have to port the code to VB6,
and compile it into what I think is called a COM file. I've never
done this myself, but it might actually be pretty easy. Use Google to
find an example VB6 project that shows how it's done.

Good luck,

Brian Murphy
Austin, Texas