In some versions of excel, you can allow the user to insert rows or columns when
you protect the sheet. Make sure that all the rows/columns in that allowed
range are unlocked.

puting_uwak wrote:

i have a worksheet with locked columns containing formulas. how can i insert
rows & copy the formula above without having to unprotect the worksheet?

--

Dave Peterson