I'm writing a code where, I will get the data from another work book and process the data on the work book with the user form then cut the data and paste to a new excel then save.
Process: Open excel where user form is (user form shown and work book is hidden) > open new work book on program and copy data > paste on main work book then process > save to another workbook.
I added Application.Visible = False and UserForm1.Show in ThisWorkbook to show the user form and hide the work book. Problem is upon hiding all the work books and opening the new work book to copy the data all other work book does not appear anymore and I don't know if it closes or still hidden. Any thoughts on this? Thanks!
Process: Open excel where user form is (user form shown and work book is hidden) > open new work book on program and copy data > paste on main work book then process > save to another workbook.
I added Application.Visible = False and UserForm1.Show in ThisWorkbook to show the user form and hide the work book. Problem is upon hiding all the work books and opening the new work book to copy the data all other work book does not appear anymore and I don't know if it closes or still hidden. Any thoughts on this? Thanks!