Need simplest VBA that sets the color of data entered in an unprotecte
cell to blue & resets it back to automatic (black) when & if a cell i
protected again.

The data may or may not be already entered. Therefore, the chang
should take place when a cell is either unprotected or protected (no
when sheet protection is turned on or off).

I prefer not having to put the VBA code in every worksheet but have i
for all workbooks & worksheets.

Any ideas?

Thanks so much for your help. mikebur

--
mikebur
-----------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...fo&userid=2458
View this thread: http://www.excelforum.com/showthread.php?threadid=48927