You might want to try using Data Validation. You can set it up so that if the
user enters anything greater than the speified value, an error window will
pop up asking them to try again. In Excel 2007 this feature is located in the
Data Tab, Data Tools Category, and it's called Data Validation.

"laureneparker" wrote:

Is there a way to not allow the user to save if values of certain cells are
greater than a specified value? If not is there a way to have a prompt pop
up when the values are too high?

Any help would be greatly appreciated.