Protection formula cell

Hello here friends,

I need your support. I have Excel file with formulas. I want to protect each cells where formula is inserted from changes or to prevent other to delete it. Protect sheet is useless.

Is any formulas or some tricks? please help me.

Thanks in advanced.

I have asked that question to another forum: http://www.excelguru.ca/forums/showt...8392#post28392

I am not time waster and i appreciate to others time and supports. I believe all of you here are to help others. So we all help each others. sorry and thanks.

In what sense is Protect sheet useless???

I have just asked the same question on another forum!

Link to the other forum now provided - thanks.

Link to the other forum provided - thank you.

You have to set cells that need to be editable as unlocked on the protection tab (cell format dialog).

Yes. You can SHIFT select blocks of them, then right-click - format - protection - uncheck (untick) the box that says 'locked'. Then, when you protect the sheet, these cells will still be editable.

The default setting for all cells is 'locked'.

Thanks. I did as u told me and it is as i wanted. Now i know how to do that. Thanks for your support. Appreciate it. I understand now about cross-posting. As i was advised i edited to my posted with a LINK.

This trouble is solved.