cell security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
In Validation box select Custom and enter the formula ISNUMBER=True.

Mike F
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pick out arguments from formula 1
Conditional Formatting with VBA 4
Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell) 3
Formula that will leave cell blank if cell is blank 1
Macro for copy and paste function 2
Summation of the Cells 1
userform exception error 4 textboxes 7
Adding up range of cells exclude hide cells 7

Back
Top