call macro after refresh query end

You do not need VBA to do this. Go to Data > Queries and Connections. Right click on query. In the properties, click OFF Enable Background Refresh. The queries will have to complete before the rest of the code executes.

I'm not quite sure it this works if you have Refresh Query on Open. If that doesn't work and you have this engaged, click it off and write some On Open code for the workbook that looks like:

Please Login or Register  to view this content.