ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   UserForm Pops Up when in the wrong file. (https://www.excelbanter.com/excel-programming/272981-userform-pops-up-when-wrong-file.html)

Jeff Marshall[_2_]

UserForm Pops Up when in the wrong file.
 
Hi,

I have 2 files that both have some VBA in them.
Both files need to be open at the same time.
One file , let's call it file "A", starts the macros by hitting Ctrl-s and
the other , let's call it file "B" , by Ctrl-t.

When i'm in the file that starts the macros with Ctrl-t (File B), a userform
that is in the other file popsup.
In all my modules I call on userforms by starting with VBAProject. ------.

Does anyone know why this happens ??
Thanks for any help in advance,
jeff








All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com