Open workbooks behind active workbook?

[jc52766]

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?

 

[JoeMo]

Just add to your code (at the beginning):

Application.screenupdating = False

Then you won't see the workbooks opening and being minimized.

 

[jc52766]

That's great! Thanks heaps