Morning and happy new year,

I have a macro that opens a separate workbook, sets the print area to 4 rows of a table and then quick prints the sheet and then saves and closes it.

When I run the macro it prints it fine but when it tries to close two dialog boxes come up both saying "this action will cancel a pending refresh" which i have to cancel and then close the sheet manually?

Is there a fix to get around these two dialog boxes?

Thanks