vba courses london - Protecting VBA code

To lock your VBA code, preventing viewing and modification, set Project Properties, using the following steps:

- Tools>Macro>Visual Basic Editor (Alt+F11).

- From within your project, select Tools>VBAProject Properties

- Click the Protection page tab and then check "Lock project from viewing"

- Enter your password and again to confirm it.

After doing this you must save, close & reopen the Workbook for the protection to take effect.