Hi
I've got a macro setup it actually has to open 10 workbooks up before caclulating in the main workbook.
I minimise these workbooks after opening so they go away but the problem is that the 10 workbooks open up over the top of the originally open workbook before minimising.
Anyway we can make these open up and not takeover the "front" of screen view whilst doing so?? Like opening them in background behind the main spreadsheet?
I've got a macro setup it actually has to open 10 workbooks up before caclulating in the main workbook.
I minimise these workbooks after opening so they go away but the problem is that the 10 workbooks open up over the top of the originally open workbook before minimising.
Anyway we can make these open up and not takeover the "front" of screen view whilst doing so?? Like opening them in background behind the main spreadsheet?