Sounds as though you have not put it in the correct module.

Have you tried conditions formatting,
http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Joel" wrote in message
...
HI can some please assist with this issue on updating Excel I have written
some code in Excel thet when you put in a certain letter in a cell it
should
turn the cell a different colour.

Now this does not happen until you go in to view code and click run, WHY?

I have set calculations to automatic in options but I still have to go
into
view code

Any Ideas many thanks





--
N/A