More Problems with Passwords

The Excel 2002 password scheme is incompatible with Excel 97. If you protected code in Excel 2002, you cannot unlock the project in Excel 97. A lot of people are still using Excel 97 out there. As your application is given to more employees in a company, you invariably find one employee with Excel 97. Of course, that user comes up with some run time error. However, if you've locked the project in Excel 2002, you cannot unlock the project in Excel 97, and therefore cannot debug in Excel 97.

Bottom line: Locking code causes more trouble than it is worth.

0 0

Post a comment