Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |