Hi Catalin,

Wow you're a genius!!! LOL Works perfect... oh and you're a life saver too as I really wasn't sure how I was going to get around this issue.

The only thing now is how can I execute this on the entire workbook?

I tried replacing: ThisWorkbook.Worksheets("TEST") =

with: ActiveWorkbook.OnEntry =

it works but I received an error when I re-opened the file again. Any ideas?

Thanks again... you rock!