View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fredy A. Fredy A. is offline
external usenet poster
 
Posts: 1
Default I want to protect a cell but allow formula values only

Hello, i have a worksheet with some formulas in it. I
have the sheet protected, but there are some cells i
cannot protect because if i do, values calculated by
formulas will not populate them. When i leave them
unprotected, there is a risk of people typing their own
value in and erasing the formula. How can i truly protect
my sheet? I want to alllow data to be populated in
certain cells, but only by formulas, not by a user typing
in whatever they want. Your help greatly appreciated.