Keep userform open when opening or closing other workbooks

[bj1280]

Thanks for the response SamT - but like I said - a real newbie to all of this. When you say

 needs to be in a separate sub and then the rest of the sub code

- are you referring to it being placed in the userform sub somewhere ??

Anyway, did that but only just kept getting compile errors or sub or function not defined errors. I get the drift of the code you have supplied, but no idea where to exactly put it - especially the

 Call Sub_to_Hide_ThisWorkbook and Call SubTo_Show_UserForm

.

Greatly appreciate your time and effort.