Userform closing error

Hi all,

I’ve an excel user form, within personal.xls, that is used to run several bits of code, basic copy and paste between sheets and workbooks. I’ve added the code to copy a sheet from one workbook to another:

Windows(TPAForm.txtopenxl.Value).Activate 'Select the xl with the sheet
Sheets(TPAForm.cbotosheets.Value).Select 'activate the sheet to copy

Sheets(TPAForm.cbotosheets.Value).Copy Before:=Workbooks(TPAForm.txtcurrxl.Value).Sheets(TPAForm.cbocurrsheets.Value)

the code works fine but the form closes afterwards, is there a way to keep the form open?

Ta

Hi Simon, thanks for the response. That’s the bit I can’t figure, I don’t have any hide or unload lines of code, the form simply closes, I thought it might have something to do with it losing focus but I have other bits of code that copy and paste data between open workbooks and the form remains open?

Closed. I've lost the plot!