Prevent worksheet Rows to Delete.

[Shazi]

Dear Sir,

I have a worksheet 'DailyPurchasing' there are some Rows having
some important formulas, if any one will remove then it will make a
big problem, and I can not hide them also. any one knows how to
restrict rows for any accidental deletion.

Rows Range: A5:A30

(I dont want to delete) from the right click menu

OR

from the

Format => Delete => Rows.

pls send me the suggessions. I will be thankfull to you.

Regards.

Syed Shahzad Zafar

 

[Per Jessen]

Hi

To prevent users from deleting cells or rows you can protect the sheet.

By default all cells will be protected when you protect the sheet. Select
the cells where data entry shall be allowed, then goto Format > Cells >
Protection > Uncheck "Locked" > Ok. Protect the sheet (enter password if
desired).

Regards,
Per