Applications.visible = false closes other work books

[vince012]

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!

 

[rlv01]

Launch Excel again, and the run some code like this:

Sub DisplayHiddenWorkbooks()
    Dim WB As Workbook
    For Each WB In Workbooks
        WB.Application.Visible = True
    Next WB
End Sub