Thank you Ken,

I have not had the chance to respond but your code for an open workbook did work perfectly. I never tested to see if the code worked on 2007 files but if you say it does I will test it out because that could help me in another issue.