ExcelBanter - Locking from deletion but can move rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Locking from deletion but can move rows (https://www.excelbanter.com/excel-discussion-misc-queries/143753-locking-deletion-but-can-move-rows.html)

Ramesh

Locking from deletion but can move rows

Hi I have large number of rows in an excel table which i send to my
collegues.They can change the data and move rows up and down.But they cant
delete the rows.Is their any thing in excel that makes me do this.

All times are GMT +1. The time now is 02:22 AM.