Tom, I have now got it to close at the end of the macro, just wondering if
there is any way of removing the close option when the window pops up, the
little x in the corner,

thanks

Andy