"Dick Kusleika" wrote in message
...

Charlie

The code is in the Declarations of the ThisWorkbook section.


It should probably be in a standard module instead of ThisWorkbook. I
can't
say why you're seeing what you're seeing, but in general, the ThisWorkbook
module should contain events and subs that directly support those event.

Well, it definately has me stumped. I have moved it to its own module and
will see what results I have. I did notice that the macro no longer has the
ThisWorkbook on the front of the name so hopefully the issue will not
reoccur.

Thanks for all your help

Charlie