Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell security
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Security | Excel Discussion (Misc queries) | |||
Worksheet Security/Cell Protection | Excel Worksheet Functions | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
Cell Security not maintained | Excel Discussion (Misc queries) | |||
Security... | Excel Programming |