prevent access to view code

  • How do you prevent a user from viewing the macro code without locking out access and changes to the excel spreadsheet that contains the macro

  • Open VBA code -> right click on the project exlorer -> vba project properties -> protection -> check "lock project for viewing" -> insert password below

    Next time you open VBA code it will ask for password before showing the code.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!