Is there a way to put a macro or vb code on a Sheet's code that will
automatically run when there is a change in the sheet. I tried to put code
by itself but it gave me an error message saying "Invalid Outside Procedure".

Thanks for your help.