I have a friend who is using a XLSM with forms in it. He wants to open another Excel file while entering the form but he can't because Forms appear to be System Modal?
(Yes he can get around it with that trick of opening Excel again and dragging the 2nd file onto the new workbook but he wants to know why you can't "just open another Excel file normally while you have the 1st Excel file open"!)
Is it possible to edit the Form code to allow another Excel file to be opened while the Form is open?
Bookmarks