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