Options for Protecting the Drop Down List
Since our data is on a different worksheet from the drop down list two options available for protecting the list data are:
- Hide the worksheet containing the data (sheet 2)
- Protect the worksheet which involves locking cells A1 to A4 on sheet 2
If security is not a concern, hiding the worksheet containing the list data is a good option since it makes it easier to update the list when needed.
If security is a concern a password can be added when protecting the worksheet to prevent changes to the list items.