Thanks mate. Will have a look. Can you think of anything else that may be causing it. Can't see it being a macro because like i said none of them are actually running when the change takes place. I will check though.