Password Protect Macro

D

Dan

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
 
J

Jim Thomlinson

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.
 
D

Dan

Thanks. I iwll look into it.

Jim Thomlinson said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top