Set color of data in unprotected cells to blue

Tech-Archive recommends: Speed Up your PC by fixing your registry


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

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

I prefer not having to put the VBA code in every work*** but have it
for all workbooks & worksheets.

Any ideas?

Thanks so much for your help. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24581
View this thread: http://www.excelforum.com/showthread.php?threadid=489272

.

Quantcast