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

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

Thanks. I iwll look into it.

"Jim Thomlinson" wrote:

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