Well met Travis. All I can do is restate that if code security is your
issue, Excel should not be your development environment. Maybe some
kind of EULA could add additional protection to your code.

Good luck!
--JP


On Sep 22, 11:37*pm, travis wrote:
On Sep 23, 4:21*am, JP wrote:

I'm curious, what kind of code does the spreadsheet have that couldn't
be found online somewhere?

I'm a financial planner. *The spreadsheet started life as a time
saving rough workbook for financial plans. *It had simple
functionality like you enter the client's date of birth and it
calculates their age and looks that age up in an actuarial table to
get their life expectancy, pension age etc.

Then much like spreadsheets often do it grew more complex. *I learned
to record macros and then figured out how to edit the code of those
macros to insert program logic. *I made a unique and highly efficient
asset allocation tool, risk analyser and portfolio creator.

- snip -

But obviously I'll want to copy protect it first. *I am aware of how
insecure Excel VBA is, having cracked open more than a few
spreadsheets in my time to see how they work. *Nevertheless, now that
I'm on the other side I want to protect my IP from being emailed to
every financial planner in the country and freely used. *:)