MrExcel Publishing
Your One Stop for Excel Tips & Solutions

re: Excel 97

Posted by Kari on May 04, 2001 8:15 AM


Is it possible to protect only the formula contained in a cell - in order to keep all users from editing the formula? Allowing data entry into the cell to continue?

Posted by Kevin James on May 04, 2001 8:20 AM

Hi Kari,

Unless I misunderstood you, it is not possible to have a formula and a manual entry in the same cell.

You can unlocked user-entry cells while leaving cells you don't want edited in the locked mode. Then, protect worksheet so that the user can only edit unlocked cells.