Thank you for your suggestions, I took your advice and made the
changes - but I still get the same results.
I've burned too much time trying to figure this out so I simply put in
a button which prompts the user to click to return to the menu (UF1).
Thank you again for taking the time to repspond
Thank you for your suggestions, I took your advice and made the
changes - but I still get the same results.
I've burned too much time trying to figure this out so I simply put in
a button which prompts the user to click to return to the menu (UF1).
Thank you again for taking the time to repspond
Are you sure the ExitApp macro you placed in your workbook Rpt1.xls
actually works without error? It seems to me that the UserForm UF1 in
that context...
Anyhow I think you can accomplish what you are trying to do simply by
placing the following event handler into the ThisWorkbook VBA module
of y
You should set a breakpoint and
try to step through your macro to see what's going on.
Which file has the ExitApp macro?
Is it in the Rpt1.xls file?
If it is, then once the activework.close line is executed,
the UF1.Show line is no longer there to execute!
also,
Once the Rpt1.xls file closes, Ex
