Thread: cell security
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scaundle scaundle is offline
external usenet poster
 
Posts: 2
Default cell security

Hi,

Is there anyway that I can stop a user adding any other value than a number,
I have put in place validation but the users can still add their own formula,
eg =sum(A1:A4)

This causes a problem as if the have added a value incorrectly into one of
the 'summed' fields it is hard to locate the error!

Thanks in advance for your help.

Steve