Microsoft VBA

I have a sheet where a branches financials are selected using a drop down box and the info is brought through from hidden tabs using a indirect formula.

I am trying to print each location without manually working through the list and printing.

I have a macro to change the location and also a macro to print, however it only prints what is shown on the screen at that time. The macro works through the changing locations much quicker than the printer is able to process the print jobs so it may end up printing every 5th location.

The only way around this i have found is to build a msgbox after each print command and it then does not print again until ok is clicked. Is there any easy way of automating a loop to not loop until after the printer has confirmed receipt of the print job?

I am guessing no, but thought it may be worth asking anyway.

Thanks,
James