Standard Add Ins Are Not Secure

Remember that anyone can go to the VBE, select your add-in, and change the IsAddin property to False to unhide the workbook. You can discourage this process by locking the XLA project for viewing and protecting it in the VBE, but be aware that plenty of vendors sell a password hacking utility for less than $40. To add a password to your add-in, follow these steps:

1. Go to the Visual Basic Editor.

2. From the Tools menu, select VBAProject Properties.

3. Select the Protection tab.

4. Check the Lock Project For Viewing box.

5. Enter the password twice for verification.

0 0

Post a comment