2. On the Menu, Click VBAProject Properties. And the Project Properties window will show up.
4. Finally, Save and close the project as well as the workbook.
When you re-open the project it should prompt you to enter the password.
How to set a Password on your Excel VBA Project
Now, for those who don't know yet How to Set a Password on your VBA Project in Excel. The guide below might be of help to you.
1. On the VBA Project Explorer. Right Click on the VBAProject(Filename.xls) on the uppermost part of the explorer.
2. On the Menu, Click VBAProject Properties. And the Project Properties window will show up.
3. On the Project Properties, Check the box Lock project for viewing. And Type and Confirm your password. Then Click OK.
4. Finally, Save and close the project as well as the workbook.
When you re-open the project it should prompt you to enter the password.
2. On the Menu, Click VBAProject Properties. And the Project Properties window will show up.
4. Finally, Save and close the project as well as the workbook.
When you re-open the project it should prompt you to enter the password.
Post a Comment
EmoticonClick to see the code!
To insert emoticon you must added at least one space before the code.