Copying cell formatting and data validation in protected worksheet

[Guest]

I have a worksheet that has several auto-calculated columns that I would like to protect to prevent users from entering values. On the other hand, users should be able to copy the last row to create additional rows for entries. When I protect the sheet and copy the row, all the values calculated from formulas paste as fixed values and the data validation rules (selection dropdowns) disappear. I've tried not marking the cells with the formulas as "locked" in the cell format dialog, but it seems to make no difference. Using events to prevent users from selecting the cells that they are not supposed to doesn't work because then the event also provents them from selecting the cells to copy the row. Any ideas would be appreciated.

 

[Debra Dalgleish]

You could try John Walkenbach's Enhanced Data Form (a free add-in) to
enter the data:

http://j-walk.com/ss/dataform/index.htm

It allows comboboxes, and should automatically copy the formulas and
formatting from the row above.