Sorry Kaper I meant no offence, I wasn't too clear in my explaination

So you can change the formulas in the name manager in VBA? That would probably solve it. Deleting them isn't an option for me