UserForm1.show fails if another workbook is open
If I have two excel files open and am running VBA application from one of them, when I try to do “User1.show”, it fails. I get a “Run Time error 9. Subscript out of range.”
However if I close the application I am not using at the moment the “User1.Show “ works as expected.
If I try to qualify the UserFrom1.Show with Workbook("Book1").UserFrom1.Show I get a compile error as "Sub or Function Not defined"
Any help would be appreciated,