I recently made an excel workbook that automatically opened a user form (UserForm) and allows the user to navigate through a series of user forms, thus never letting the user have access to the actual worksheets. This is useful to prevent erroneous data from being entered in the worksheets. I ran into a small problem, though. When users wanted to open other Excel workbooks in order to copy data, etc. the workbooks were not displaying. To solve this problem I used the Application.IgnoreRemoteRequests method.
By setting Application.IgnoreRemoteRequests = True upon opening the workbook, the user can now open other workbooks in a different Excel browser that will not interfere with your workbook.
Just be sure to set Application.IgnoreRemoteRequests = False when you close the workbook or you could run into problems!
