<div>
i would definitely try putting permissions on the file to prevent unwanted / unneeded manipulations of the file by users that should not be editing it
</div>


i would definitely try putting permissions on the file to prevent unwanted / unneeded manipulations of the file by users that should not be editing it

<div>
this articles describes some of the how -tos <br />
<br />
<a href="http://office.microsoft.com/en-ca/excel-help/lock-cells-in-a-worksheet-HA010342979.aspx" rel="ugc">http://office.microsoft.com/en-ca/excel-help/lock-cells-in-a-worksheet-HA010342979.aspx</a>
</div>


this articles describes some of the how -tos

http://office.microsoft.com/en-ca/excel-help/lock-cells-in-a-worksheet-HA010342979.aspx [http://office.microsoft.com/en-ca/excel-help/lock-cells-in-a-worksheet-HA010342979.aspx]

<div>
Thank you hgholt, this is exactly what I was looking for. &nbsp;<br />
<br />
Eric
</div>


Thank you hgholt, this is exactly what I was looking for.  

Eric

<div>
<div class="content wysiwyg-content">
I have an Excel 2007 spreadsheet that is routinely corrupted because users insert cells instead of row. &nbsp;User training should have fixed this issue but it did not…. &nbsp;So is there a way to prevent inserting selected cells or force the selected range to change from selected cells to selected rows?<br />
<br />
Thank you <br />
Eric
</div>
</div>


I have an Excel 2007 spreadsheet that is routinely corrupted because users insert cells instead of row.  User training should have fixed this issue but it did not….  So is there a way to prevent inserting selected cells or force the selected range to change from selected cells to selected rows?

Thank you 
Eric

Can I allow insert row but prevent insert cell

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