Hi,

I've never played with Data Validation - Warning before but
I think you may need to unlock the cells that you applied
the validation to.
Select cells and goto Format CellsProtection Tab and
uncheck 'Locked'.

HTH
Martin



"Excel(lent) student" <Excel(lent) wrote
in message ...
I am just learning how to use Data Validation in an online college course I
am taking. My assignment is to set the Data Validation to warning and
then
deliberately enter invalid data to set off the warning. Then I am supposed
to
use the Formula Auditing toolbar to hightlight the invalid data and make
the
red circle appear.

Everything works great until I try to protect or save the workbook, then
the
red circle around the invalid data disappears and the Formula Auditing
toolbar is greyed out in the areas I need to use.

Has anyone got an answer for this?