Excel compilers

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I need to learn about compilers. I have designed an
Excel template that I would like to license to clients
without losing control of the code. Ideally, the client
would be able to change unprotected input cells, not see
my formulas, not be able to copy anything, would work for
a specified number of uses or time. My ignorance on the
subject is unlimited. Thanks for your time.
 
Steve,

Since you've mentioned compilers (there are none, as far as I know), I
presume you mean macros (either subs or functions). You can lock the
project (in the VBE, Tools - VBAProject Properties - Protection - Lock
project for viewing, with password). This isn't real secure. It'd be nice.
But it ain't. It'll keep the honest and the inept out.

I don't know of a way to prevent copying.
 
Steve said:
I need to learn about compilers. I have designed an
Excel template that I would like to license to clients
without losing control of the code. Ideally, the client
would be able to change unprotected input cells, not see
my formulas, not be able to copy anything, would work for
a specified number of uses or time. My ignorance on the
subject is unlimited. Thanks for your time.

There's no Excel compiler. Spreadsheets generally are terrible when it comes
to security and hiding how things work from users. So, as a practical
matter, if you can't or won't trust the honesty of your potential users,
you're going to need to rewrite your application in a real programming
language that you can compile into a stand-alone executable.
 
Back
Top