Hi
I have a form in a workbook "tools.xlsx" that I use to enter data into a worksheet . I need to open another excel workbook to enter more data.
I can open a new workbook fine using a 'getopenfilename' method from my userform. Opens the file fine but the new workbook is stuck behind my 'Tools' worksheet and I can't add data. I tried to activate the workbook and that didnt work either.
Am i going to have trouble opening a workbook when i still have a userform open in "tools.xlsx"
Thanks Dave
I have a form in a workbook "tools.xlsx" that I use to enter data into a worksheet . I need to open another excel workbook to enter more data.
I can open a new workbook fine using a 'getopenfilename' method from my userform. Opens the file fine but the new workbook is stuck behind my 'Tools' worksheet and I can't add data. I tried to activate the workbook and that didnt work either.
Am i going to have trouble opening a workbook when i still have a userform open in "tools.xlsx"
Thanks Dave