Copy a protected row?

T

Tom82

I have a predesigned row of which a few cells are locked. If I protect the
sheet and I copy this special row to somewhere else in the sheet the
protection on the specific cells will disappear! How can I solve this?
I basically have a database in which I have to enter rows from time to
time.... To keep the formulas and formats I want to use a standard
predesigned row, so that after entering the row (insert copied cells), the
necessary cells are blocked automatically....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top