Tezzies
02-14-2008, 12:14 PM
This is a strange problem that seems to have crept into a project I'am working on. I'll give a brief description and if this rings any alarm bells please feel free to enlighten me because I am really stumped.
I have a workbook called main.xls. It has a userform which has a series of combo boxs and buttons which when pressed opens another workbook called test.xls. Once opened test.xls does some stuff then closes itself. Once closed i expect my userform which is embedded in main.xls to be visible again. Instead sheet1 from main.xls is visible and any macros within Main.xls do not continue. BUT If I repeat the process and step through slowly using F8 it works as expected :dunno.
Is there a setting or update required or maybe a line of code missing to cure this hopefully common fault.
many thanks
I have a workbook called main.xls. It has a userform which has a series of combo boxs and buttons which when pressed opens another workbook called test.xls. Once opened test.xls does some stuff then closes itself. Once closed i expect my userform which is embedded in main.xls to be visible again. Instead sheet1 from main.xls is visible and any macros within Main.xls do not continue. BUT If I repeat the process and step through slowly using F8 it works as expected :dunno.
Is there a setting or update required or maybe a line of code missing to cure this hopefully common fault.
many thanks