Select you range of cells to protect
then in the Main Menu goto
DataValidation
on the settings tab
under the 'Allow' Drop box select whole number
then use 1 or 0 as a minumum and 10 as a maximum


--
When you lose your mind, you free your life.
Ever Notice how we use '' for comments in our posts even if they aren''t
expected to go into the code?


"Amy Stein" wrote:

I have a worksheet with a range of cells that have a SUMIF function
based on entry into another range of cells. How can I prevent user
entry that will cause these cells to exceed the value of 10?


Thanks in advance for any help.


Amy