You could create a Com or Automation addin. That is done via
VB or C/C++
or... That will create a compiled executable. To get it into
VB or whatever
language you choose will require some modifications. There is some excellent
inof out there on createing com and automation addins.
--
HTH...
Jim Thomlinson
"Dan" wrote:
I understand that the only way to protect project/macro is to open the VBA
Editor, go to the Tools menu, choose VBA Project Properties, then the
Protection tab. There, check the "Lock Project For Viewing" option and supply
a password. But VBA passwords can be cracked using software readily available
on the net.
I want to be able to distribute the spreadsheets with the macro but deny the
user access to the macro.
What would be the best/easiest way to create a standalone application? Could
the existing code be imported directly or would modifications be required?
Thanks