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
What would this be - any ideas / fixes ?
Thank You
Allister
VBA Code:
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