Maintaining Protection when copying

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have locked certain cells in a row and I have want to copy the row. When I
copy the row, the cells in the copied row do not keep the locked status. Is
there anyway to do this? We want to be able to copy the row because it is a
template row. We want to beable to change some info but definately certain
cells need to remain locked.

If anyone has any helpful hints, they are all appreciated.
Thanks
Jessica Wilson
 
I created a workbook with two worksheets.

On sheet1, I unlocked columns C:E.
I protected that sheet

I copied row 1 from sheet1 and pasted into A1 of sheet2.

The cells that were locked were still locked. The cells that were unlocked were
still unlocked.

I used xl2003.

Is that what you did?
 
You must log in or register to reply here.

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

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Can a row containing protected & unprotected cells be copied? 8
Move cell and maintain reference 4
Excel 2007: Insert Row into Defined Area & Inherit Above Formulas 4
Selecting rows. 3
Protected Sheets 2
Why is AutoSum iinoperable w/protection when column is unlocked? 2
allow insert rows = false for only some of the worksheet 1

Back
Top