Hi Iain,
Do you need to just disable the change event to solve the issue? (I haven't downloaded your file to look.)
If so, just throw this in in the beginning:
Don't forget to set it back to true at the end though.Application.enableevents = false
HTH,