Thread: portected cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Folwell John Folwell is offline
external usenet poster
 
Posts: 2
Default portected cells

I have created spreadsheets with unprotected areas for data entry. The data
is used in formulas in protected cells. If the user enters data in the wrong
cell and moves it to the correct cell, the formulas are changed. Is there
any way to prevent the corruption of the formulas by the users action?