![highlight locked cells excel highlight locked cells excel](https://www.excel-university.com/wp-content/uploads/20140507c.png)
Let’s say you want to freeze your data so that it will show only the column’s heading.
#Highlight locked cells excel how to#
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.
#Highlight locked cells excel code#
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.
![highlight locked cells excel highlight locked cells excel](https://cdn.extendoffice.com/images/stories/doc-excel/select-locked-cells/doc-select-locked-cells3.png)
Enter the password you wrote on the VBA code.