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).Sheet(TPAForm.cbocurrsheets.Value)
the code works fine but the form closes afterwards, is there a way to keep the form open?
Ta
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).Sheet(TPAForm.cbocurrsheets.Value)
the code works fine but the form closes afterwards, is there a way to keep the form open?
Ta