I have a VBA macro that gets information from the user. Sometimes the user wants to open another Excel workbook to find the information to cut/paste. The problem is that while the userform is open, the second workbook won't open.
If there was an event that indicated the user tried to open another workbook, my VBA macro could launch another copy of Excel. Is there such an event?
Is there another way to do this?