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,