I am refreshing the table query on a protected sheet. I use below code that works fine however, as soon as I add one more command to protect sheets back - i get Run time error 91: object variable or With block variable not set Dim wSheet As Worksheet For Each wSheet In Worksheets wSheet.Unprotect Password:="password" Next wSheet Application.ScreenUpdating = False Sheets("Available_Stock").ListObjects(1).QueryTable.Refresh BackgroundQuery:=False Any ideas why??

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Refreshing table query on a protected sheet

Thread starter karolina1406
Start date Aug 14, 2020

karolina1406

Board Regular

Aug 14, 2020

I am refreshing the table query on a protected sheet. I use below code that works fine however, as soon as I add one more command to protect sheets back - i get Run time error 91: object variable or With block variable not set

VBA Code:

Dim wSheet As Worksheet
For Each wSheet In Worksheets
wSheet.Unprotect Password:="password"
Next wSheet
Application.ScreenUpdating = False
Sheets("Available_Stock").ListObjects(1).QueryTable.Refresh BackgroundQuery:=False

Any ideas why??