How to freeze rows and columns in excelįreezing is not a lock option but when there is big data that you are analyzing and you want to work in a specific location of your excel file freezing the data is an effective way of doing that.
Note: Unlocking the cells after applying the VBA code follows the same unlocking method explained earlier. After this whenever you want to edit the desired cells of the excel you will see a warning box indicating that you cannot edit the cells as it is protected.
Enter the password you wrote on the VBA code.
First, we will need to select the cells we want to lock.Read More… How to lock certain cells in Excel