As user interaction on an Excel sheet becomes required, there is often a great deal of information that you do not wish to allow the user to see. This information may include formulas or conditional messaging. Also, you may wish to prevent users from adding or removing information from the worksheet beyond what you specify.
In this recipe, you will learn how to lock cells in your worksheet to only allow specific interactions.
To begin, we will need to ensure cells are locked. By default cells are locked in Excel; however, it is still good practice to verify that cells were not inadvertently unlocked: