Hi,

Is your userform in the same workbook as that macro? If it is, the answer is very simple: you can't because you closed the workbook containing the userform.