The following thread has very nearly the same issue. NBVC solved it and pasted the workbook with the solution in it.
http://excelforum.com/showthread.php?t=637916
HTH