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

Hi Mike,

Thanks it for the email, but this now does not let me allow me to type any
data into the cell.

When I do it also comes up with the 'The value you entered is not valid.'
stop error alert message box.

Do I need to add the number range to make this work, I need 0 to 10000?

Thanks in advance for your help.

Steve

"Mike Fogleman" wrote:

In Validation box select Custom and enter the formula ISNUMBER=True.

Mike F
"scaundle" wrote in message
...
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