Insert Copied Rows or Drag/Drop Formulas While Protected

  • Thread starter Thread starter veggies27
  • Start date Start date
V

veggies27

I am working with a worksheet that has the cells with formulas protected, to
prevent end users from modifying or overriding them (specifically column E).
My problem is I need to be able to add rows (Say 3 new rows between rows 1
and 2-which will mirror rows 1 and 2 exactly), and have the formulas in those
protected cells in the adjacent rows copied into the new rows. I can't copy
the existing row and "paste copied cells" to add the row with all the correct
formulas while the sheet is protected. I can insert a blank row, and in
theory drag and drop the 1 cell with a formula (E1) down to work in the new
row, but this is also not allowed while protected. Any suggestions?
 
Hi

The sheet needs to be unprotcted to paste formulas!

Regards,
Per
 
Use a macro to unprotect, do your job then re-protect

Sub do_it()

ActiveSheet.Unprotect Password:="justme"

code to do your work

With ActiveSheet
.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
.EnableSelection = xlUnlockedCells
End With

End Sub


Gord Dibben MS Excel MVP
 
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
Excel 2007: Insert Row into Defined Area & Inherit Above Formulas 4
Insert/ delete row in protected worksheet 7
insert rows--->protected sheet 1
keeping same-row(or column) cell constant in a formula while drag- 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
drag formula down from columns that go acros 3
Insert row with a locked cell 1

Back
Top