I have an excel sheet with a macro that changes the colour of cells depending on their content. The problem I have is that the macro only runs for 1 of the sheets and not the others.
Does anyone know how to go about making it run on all sheets?
the code so far is:
Please Login or Register to view this content.
I've also attached a screeshot of the code, Im using excel 2003, Most of the sheets are password protected as well if that makes a difference?