Next time you open the workbook and try to view the code you will be prompted for the VBA password. Save the workbook as Excel Macro-Enabled Workbook format, and then close it so that the password protection takes effect. On the Protection tab, check the ' Lock project for viewing' option, then type and confirm the password that you want to protect the VBA macros/code from viewing.

Let’s rock and roll with some easy examples to get you writing code in a spreadsheet using Visual Basic. Click the Tools menu and then choose VBAProject Properties. First, let’s create a file for us to play around in. This will open the Microsoft Visual Basic for Applications window. Also if I install the Office 2013 reference, is the use of it similar to the older Excel 2010 Help and does it have similar search features. Right-click on any worksheet tab at the bottom of your screen, and then select View Code. I dont want to install an old version and cause a problem with my Office Professional 2016. Open the Excel file in Office Excel 2016 / 2013. Password Protect VBA Project in Excel 2016 / 2013 In this dashboard tutorial you will learn how to insert map chart, and call each map using Excel VBA function. In this tutorial we'll show you how to lock VBA project with a password in Excel 2016 / 2013. How to Create a Dashboard in Excel VBA Using Userform and Map Chart.

How can I lock down the VBA project to prevent others from seeing or messing up your code? Just like you can use password to protect a workbook or worksheet, you can also set a password to protect VBA macros in Excel.

How to install vba in excel 2016