Hi Listers,

We have created a heavy excel application with around 500 macros in
it. The application itself is in the different sheets of the workbook.

My queries are:

1. How can I hide all my macro code? I dont want to use protect
workbook option as that password is not that secured.

2. How can I create a setup or .exe of my macros? I can create addins
but the code will still be viewable by the user so I don't want to
create addins.

3. If I have to sell this application then I need to license it too.
What are the option available to make it licensed app and how can I do
it?


Regards
Ankur

I'd suggest you get a book that covers a lot of that.

Professional Excel Development has a section on that:

http://www.amazon.com/Professional-E...4931678&sr=8-1

One of the items it covers is: "Providing help, securing, packaging
and distributing"

Worthwhile investment since there are a lot of considerations.


On Nov 12, 11:08 pm, Ankur <gulatian...@gmail.com> wrote:
> Hi Listers,
>
> We have created a heavy excel application with around 500 macros in
> it. The application itself is in the different sheets of the workbook.
>
> My queries are:
>
> 1. How can I hide all my macro code? I dont want to use protect
> workbook option as that password is not that secured.
>
> 2. How can I create a setup or .exe of my macros? I can create addins
> but the code will still be viewable by the user so I don't want to
> create addins.
>
> 3. If I have to sell this application then I need to license it too.
> What are the option available to make it licensed app and how can I do
> it?
>
> Regards
> Ankur