Settings to protect a data entry sheet?
Posted on 2014-04-01
Hello - I have worked up a data entry worksheet where the users would make entries into cells of a data table (entering new rows after existing rows at the bottom of the table).
Most of the entries are in the form of data validation lists, and there are hidden columns with formulas that I don't want them to unhide.
At first glance, I thought the default options of "Protect Sheet" would be what I needed, but it won't let me select a value from the first visible column (that uses a data validation list) on the first blank row ("The cell or chart you are trying to change is protected...")
What am I missing?