Sql on closing Excel

[LAS]

I am runing an update query from excel to a sql database.

The query runs correctly when run BUT,

I also run the query when the workbook closes. At that point I get the following Excel message:
'The action will cancel a pending Refresh Data Command. Continue?'

If select OK the query does not complete, nor does it run if I cancel.

Any ideas how to stop excel from closing the workbook until the query / code has finished running?

Thanks fro your help.

[Juan Pablo González]

Uncheck the 'Background Query' property of the query.

[LAS]

Thanks for the fast reply.

It didn't help.

I have the following code that runs when closing the workbook:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    AcademicPopulate
    RemoveCustMenu
End Sub

It seems to skip over the AcademicPopulate module and only run the next procedure (RemoveCustMenu).

If I step through it (F8) all runs OK but when closing the workbook it doesn't seem to run the first procedure.

Any further ideas?

[LAS]

My sincere appologies. I found my bad code.

I changed sheets in the middle of the code which resulted in me exiting the procedure.

Sorry to bother everyone.