View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 'very hidden' columns

The technique works for VBA add-ins, too, though the macro would require
some modification, or the add-in would have to be restored to a workbook
- which takes all of about 2 seconds in the VBE. It's true that VBA
Password protection is different than worksheet protection, but it can
be bypassed as, or more, easily than worksheet protection. It's anything
but "unbreakable".

Compiled add-ins (COM add-ins) are not susceptible to this technique.
However XL97 doesn't support COM add-ins.

The bottom line is that XL is an extremely poor application for keeping
data secure.



In article ,
"arno" wrote:

Is this about Excel 2000, 2002, 2003 or also true for Add-Ins written
an protected with Excel 97? I somewhere heard that XL97 Add-Ins cannot
be cracked because the VBA-Password-Protection worked in a different
way. So, does it make sense to use XL97 to make "unbreakable" files
(that do not need functions added in later versions)?