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!

Register Yourself Login