When you write a code to select comments it will select the notes that you have in the range specified. Right-click on any worksheet tab at the bottom of your screen, and then select View Code. In Excel, old “Comments” are now “Notes”. Password Protect VBA Project in Excel 2016 / 2013 Open the Excel file in Office Excel 2016 / 2013. So here in my case, I have used the cell A10 and the same I got in the message box. Now when you run this code, it will show you a message box with the address of the cell that has been used last (typed). Set myRng = Range('A1:A10').SpecialCells(xlCellTypeLastCell)

In the end, use the address property with the variable to the get the address of the last type cell.

From here, you need to use a VBA message box to get the address of the cells returns by the special cell method.

Next, set that special cell line of code to the variable that you have defined in the first step.

After that, refer to the range and use the “SpecialCells” method where you need to specify the “Type” argument with “xlCellTypeLastCell”.

First, declare a variable as range to store that cell address returned by the code.

Note that, in the special cell method there are two arguments out of which one is required and the other is optional. Next time you open the workbook and try to view the code you will be prompted for the VBA password.Here we are writing code to know the address of the cell which is used last from the range A1:A10. 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. Click the Tools menu and then choose VBAProject Properties. This will open the Microsoft Visual Basic for Applications window.

Open the Excel file in Office Excel 2016 / 2013. Password Protect VBA Project in Excel 2016 / 2013 In this tutorial we'll show you how to lock VBA project with a password in Excel 2016 / 2013. 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 write vba in excel 2016