View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default VBA Codes Protection

An add-in is no more secure than any other workbook.

If you really want to protect it, you need to write the important code in a
compiled language, such as VB, as a DLL say, and call the DLL in your
application.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mike H" wrote in message
...
VB code protection is more robust than workbook/sheet protection but
inexpebsive commercial crackers will remove the protection very quickly.

The only safe method is to create you code as an add-in.

http://msdn2.microsoft.com/EN-US/lib...ffice.10).aspx

Mike

"Varne" wrote:

Hi

I like to protect my VBA application. I know Excel sheet password can be
broken. Even I can do it. But is it easy to break into VBA codes
protected
for viewing?

If you know it I do not want to know how to do it because I am not going
to
do it. But can you tell me how can I stop it? Will I have to merge some
other
technology with Excel?

Thanks & Regards

M Varne