Power Query refresh button not working where backgroundquery = false

Hi Guys,

i am using code to refresh querytable from power query:

Sub RefreshListObject()

With Worksheets("DNS Export Table")
    .ListObjects(1).QueryTable.Refresh
End With

MsgBox "done"

End Sub

and it is working like a charm.
I read that i should add also:

With Worksheets("DNS Export Table")
.ListObjects(1).QueryTable.Refresh FALSE
End With

"false" in the end to turn off "Enable backgroundquery" property.
But when i am doiing this macro stops after refreshing so msgbox is not showing up...

Why ? Did you have similar issue?
Please help,
Jacek