<div>
I would normally suggest a Table, but they don't work with sheet protection on. You can set Formulas and Formats to copy down in Excel Options, this might work.<br />
<br />
File -&gt; Excel Options -&gt; Advanced. The sixth CheckBox down in Editing Options.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/12_w49/1131429/Screenshot-2016-12-03-18.17.53.png" target="_blank" title="Screenshot-2016-12-03-18.17.53.png (40 KB)"><img alt="Screenshot-2016-12-03-18.17.53.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2016/12_w49/800_1131429/Screenshot-2016-12-03-18.17.53.png" /></a>
</div>


I would normally suggest a Table, but they don't work with sheet protection on. You can set Formulas and Formats to copy down in Excel Options, this might work.

File -> Excel Options -> Advanced. The sixth CheckBox down in Editing Options.

Screenshot-2016-12-03-18.17.53.pnghttps://filedb.experts-exchange.com/incoming/2016/12_w49/1131429/Screenshot-2016-12-03-18.17.53.png

Screenshot-2016-12-03-18.17.53.png

<div>
You may be better off protecting cells using the UnserInterfaceOnly setting of the Protect method. For example:<br />
Sheets(&quot;Sheet3&quot;).Protect UserInterfaceOnly:=True<br />
<br />
See this <a href="https://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.protect(v=vs.100).aspx" rel="ugc">MSDN article </a>for details.
</div>


You may be better off protecting cells using the UnserInterfaceOnly setting of the Protect method. For example:
Sheets("Sheet3").Protect UserInterfaceOnly:=True

See this MSDN article [https://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.protect(v=vs.100).aspx]for details.

<div>
Does the workbook add the lines using VBA?
</div>


Does the workbook add the lines using VBA?

<div>
No, the user just copy/paste the entire last line
</div>


No, the user just copy/paste the entire last line

<div>
Have you tried my suggestion?
</div>


<div>
Options are already cheched like the one you suggest<br />
It does not change the behavior, not possible to copy/paste a line ...
</div>


Options are already cheched like the one you suggest
It does not change the behavior, not possible to copy/paste a line ...

<div>
<div class="content wysiwyg-content">
I have prepared a customer's spreasheet where columns H,I and J are protected (contain repetitive formula, line by line)<br />
I want the customer to be able to replicated lines : at the beginning, lines 1 to N are used, but I want my customer able to copy line N to line N+1 if needed etc...<br />
Is this achievable without unprotecting these columns ?
</div>
</div>


I have prepared a customer's spreasheet where columns H,I and J are protected (contain repetitive formula, line by line)
I want the customer to be able to replicated lines : at the beginning, lines 1 to N are used, but I want my customer able to copy line N to line N+1 if needed etc...
Is this achievable without unprotecting these columns ?

Cells protection in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.