If he can *even get* to the validation window, that means the sheet isn't
protected.

Anyone who doesn't protect a sheet, even *without* a password, shouldn't be
creating any sort of restrictions that can so easily be breached as by
simply clicking on the toolbar.

If the OP finds and by-passes the validation,
IMHO - the sheet creator deserves what he gets !<vbg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Ken Wright" wrote in message
...
which you can change.

Or find out why it was there in the first place and if there was valid
reason that negative values were prohibited :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--

"Ragdyer" wrote in message
...
Select one of the cells with the error message, and then:
<Data <Validation,
And see if you get the validation window with a formula, which you can
change.
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-

"CML" wrote in message
...
In Excel, I get an error message when trying to enter a negative
dollar
amount. "You must enter a dollar amount in this cell." How do I enter
a
negative amount without the error message and still have it add up
correctly
at the ending column?