Allowing macro to run while typing words into cells

Is it possible to have a macro in a row of cells and then type words into one of those cells without having the macro stop? When I type in a cell that contains a macro, it gives me a run time error.

I've attached a sample file of what I'm trying to do. On the sheet titled "Day1", row 6 has a macro. If I were to type "out" or "dog" for example, in one of the cells, what do I need to change in order to have the macro keep running. I've protected the work sheet and locked all the cells that I don't want used, but I'm not sure how to get past this problem. Thanks for the help.

Cellar Webs

Thanks for the reply. I already know that the cells will do the calculation but say I typed a word into that cell. Well, it says "Run-time error '13': Types mismatch." Is there a way that I can still have the code work even though I might type a word into that cell instead of a number?

Cellar Webs

Where would I paste this code? Thanks for the help.

Cellar Webs

royUK,

Thanks so much! It worked. Thanks for replying so quickly.

Cellar Webs