Password protected VBA code in Excel

Follow the below steps:

Open Excel Workbook and go to Tools>Macro>Visual Basic Editor (Alt+F11).

Now, from within the VBE go to Tools>VBAProject Properties and then click the Protection page tab and then check "Lock project from viewing" and then enter your password and again to confirm it.

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

By Perry    Popularity  (2967 Views)