Macro only Runs on step-Through

[AllisterB]

I have a workbook with a PQ to a Table . the Table sits on a protected Sheet. When I run the macro with Step-Through its fine. If I run it normally I get a message.
What would this be - any ideas / fixes ?

Thank You


Allister

Sub RefreshAllacb1()
Dim ws As Worksheet
For Each ws In Worksheets
    ws.Unprotect
Next ws
ActiveWorkbook.RefreshAll
Application.Wait (Now + TimeValue("0:00:05"))
For Each ws In Worksheets
    ws.Protect
Next ws

End Sub

 

[AllisterB]

I solved this by disabling Background refresh on the Power Query